"So as manufacturing pathfinder, this is what success often looks like. "
If blowing up a prototype enables changes to the manufacturing process that prevent the same thing happening later with a live crew on board, then it's considered a success. It doesn't matter who the CEO of the company happens to be.
AFAIK nobody has built something like this before. To have it fail during an early test doesn't seem unusual.
Suppose SpaceX had used a very similar prototype, but some process or engineer had caught the fault. Few here would be taking the lack of an explosion as evidence that SpaceX are not innovative. Instead, if anything, they would be praising the superb processes in addition to the cool prototype.
So, there is always room to improve. The reaction to this essentially anodyne point here has been really interesting.
See also: Soyuz 1, Soyuz 11, Challenger, Columbia, Apollo 1 - and that’s purely spacecraft which have killed people, never mind the vast list of experimental aviation deaths.
Much better to blow up some prototypes than some humans.