I don't really understand what people's expectations were for a new vaccine intended to combat an ongoing global pandemic.
You don't get vaccines in use for 50 years without vaccines in use for 1 year, and you don't get that without using them for 6 months, and you can say the same about COVID-19 vaccination. Arguing otherwise is just failing to understand linear time.
You should say that COVID-19 vaccination had net very good outcomes too, unless you're a wilfully ignorant conspiracy theorist.
The safety factors of a vaccine become better understood over time and use, and you can say the same etc.
The bar isn't "perfect vaccine", the bar is "significantly better than no vaccine". And this depends on the urgency of the situation.
The only "debacle" is a political/sentiment one. MRNA vaccines are a significant new medical tool, not just for COVID-19.