I also saw an Elon Musk tweet today. Today. People still have no clue what the Covid Vaccine does. We've had this Flu Vaccine for decades and they are pretty similar (not in design) in use, effectiveness, etc. I don't really understand why there is such a disconnect.
I think the Covid vaccines in the US are far more effective than any flu vaccine, but otherwise I agree. Vaccines aren't meant to be prophylactic. They do have a lot of that in them, but the goal is and has always been to reduce severe illness and death. As an ancillary benefit, they substantially reduce transmission and depending on the target, can effectively eradicate them with enough uptake.
But we see those ancillary benefits as being the only benefits, unfortunately.