Even with a high rate of vaccination it will unfortunately be impossible to eradicate SARS-CoV-2. Unlike smallpox or polio there are animal reservoirs. And while the vaccines are very effective at preventing deaths they don't really stop the spread. Any notion of wiping it out is simply wishful thinking not grounded in scientific reality.

The most likely scenario is that almost all of us will eventually be infected no matter what we do.