70% of the population in the US have had two or more shots at this point. IDK if you've been outside recently but I'm pretty sure vaccinated people aren't hiding away in numbers that would cause anything even close to the massive discrepancies in hospitalization and death between vaxxed and unvaxxed.

is the data probably confounded to some degree? sure. Is it overwhelming despite that? yes.

In case you care to look at smaller amounts of data that won't have as many confounding variables, you could check out any of the many studies evaluating vaccine effectiveness among healthcare workers who would all have regular exposure to the virus.