I think most people would have expected it to. Whether that's a reasonable expectation or not is up for debate. But yeah, many if not most people in the US were convinced that COVID was a threat so severe that it warranted completely uprooting life as we knew it. A sizeable minority of people are convinced that COVID vaccination is so important that people should be coerced into it by almost any means necessary. So I think understanding that we don't have a single randomized controlled trial that actually shows a reduction in all-cause mortality when given this intervention is pretty important.

It's a general principle of medicine (or at least, it used to be) that the important outcomes are the actually clinically relevant outcomes. Did people die less? Did they achieve a better quality of life? When you get into proxy metrics you get to this weird place where you can show that something is insanely effective for proxy metric X, and yet it makes no difference (or is even deleterious) in thing-you-actually-care-about Y.