And what is the population of vaccinated people compared to the population of unvaccinated people? What percentage of vaccinated people got boosters later after immunity waned? The increased proportion of vaccinated unvaccinated over time is why it was always predicted that vaccinated people would eventually be the majority in hospitals and among the dead (ie. with the large majority vaccinated, there are simply many more opportunities for the virus to kill a vaccinated person). You’re much more likely to die or get the virus if you’re unvaccinated:
https://covid.cdc.gov/covid-data-tracker/#rates-by-vaccine-status
The vaccine does and did do what they said it would do, but we now have a much more virulent form of COVID than when the vaccines were designed, you need boosters to make vaccines more effective, and the prevalent variant isn’t as dangerous as initial variants so it makes immunity less important for most people, for now.