It's good to see you in the Community! To answer your question, contacts will be resubscribed to your mailing list immediately once they click on the "Confirm Your Subscription" link in the resubscribe email.
Take a look at the article for adding back an unsubscribed contact if you need it.
If you have any further questions, please don't hesitate to reach out. We're happy to help!