Clearly, you are comparing spaceships to social media and they ain't the same!
Thank you for the first part, where you rightfully acknowledge that the launching was the success and well blowing up was not a bad thing. Clearly, you have not let the biases of mainstream media (rockets cause dust, waste of money etc) cloud your narrative.
Second part is not well thought of. Twitter was clearly sinking money and doing more of the same was not an option. Also, the idea that you have to listen to what people want and do is not always the right business model. Twitter was infested with bots and had no profitable path to revenue, when it had so much potential. You need to rock the boat and try a few things before one sticks out, which is what Elon is attempting you. The media being biased starts projecting it as thoughtless, vainful exercises, when it's probably not the whole story.
Long ramble, let me put it another way: Do you think twitter was on path to economic success before or after Elon Musk took it over? If you think its before, then present what *experiments* were they trying? If it's after, clearly, we have quite a few of them listed and not just the 8$ verification.