Wait a minute. It is not that NASA when developed the rocket that culminated with the Apollo V did not even had a rocket exploding, they had their fair share of failures (and some even letal).
But the main difference is that SpaceX and NASA have different approaches: NASA cannot, for various polical reasons, tolerate a rocket exploding during a test, SpaceX can.
I would argue that NASA, in its current incarnation and political situation, would never be able to design, build and manage something like the Falcon 9.
So Musk is not ruining SpaceX with the Starship failures in my opinion, since it is inherent to SpaceX that way to work.
Then that Musk is sometime a little too borderline is true, but I suppose that now he cannot really ruin any of his companies, for whatever you can think about him I really doubt that he is that stupid.
Stop electing stupid people and maybe you will get something.
Stop treating every opinion as worth of discussion even if it is clearly stupid.
Start to propose some reasonable solutions and start to pass over the NIMBY syndrome.
(and no, only stopping to use ICE cars or fossil fuel is not a reasonable solution until you propose a sustainable alternative solution)