If you're waiting for the CDC to give you their blessing and for us to know how things will be 9 months later, you'll be staying at home for the next few years. I think we are approaching herd immunity - not there yet - but within months. About 15-25% have been vaccinated and another 20% have had "nature's vaccine". 25% are under age 18 who are mostly unaffected. A couple million more people get vaccinated every day, and those that have been vaccinated are the most vulnerable.
No one wants to celebrate prematurely and there may be areas that see increases in "cases" but CDC data shows new cases are in a nose dive. The charts are similar for hospitalizations and deaths.
COVID Data Tracker Weekly Review
Since most of the tourists coming to Mexico are Americans what is happening in America is quite relevant to what will happen in Cozumel. Does anyone have a comparable source with graphs for cases, hospitalizations, and deaths in Cozumel or QRoo?