We did accidentally torch the Apollo 1 crew in their capsule.
My fav Apollo-era fuckup is when they tested the launch abort system. The test went bad, but was 100% successful in demonstrating it worked. Heh. https://www.youtube.com/shorts/DpdKxv9WINY
Over on the nuclear side there was SL1, which AFAICT is probably the answer to the question "why doesn't the US Army have its own nuclear systems?" https://www.youtube.com/watch?v=qOt7xDKxmCM .
"Explode until you figure it out" served Falcon 9 well.
I'm inclined to see Constellation/SLS/Orion/etc. as at least as wasteful as the explosions, at least so far. Which one wins out will depend on the end results.