This is a question that comes up internally as well. It gets into questions like "Why do we fund the Thunderbirds etc". I will hold off on my 2c because the arguments are already covered!

Immediately after a show like this, yes, it looks foolish to lose 2 combat planes and almost 4 aircrew for a performative event. Looking at it more generally, it's a tradeoff.