I don’t remember missile and gun shoots during the Point Mugu Air Shows I attended.
I remember one year there was a Harrier jump jet, and when that plane stopped and hovered in mid-air it was a real show stopper.
I don’t remember an SR-71 fly by....lots of F-14s, A-6 Intruders, and an occasional E2C Hawkeye and EA6B Prowler.
1970-80s era shows, launch a Sidewinder at a dropped flare over the ocean, another F-14 would cut loose a 20mm burst passing by the show center. An A-7 did a toss dummy bomb drop to show how they would deliver a tactical nuke. Amazing how far and high it soared.
I would guess PC infected the shows and later ones were pale versions of the old stuff. Sort of like happened to fireworks displays. No more crowd pleasers.