Will COVID-19 ever **** off?

Well - there is few things that could happen.

1 - the best one - everyone will get vaccinated, and will fight against it. Then it can become the new flu.
2 - antivaxers will fight till the end, and governments will be forced to stay in this regime and that can transform in new global crisis.