But I think your benefit of the doubt in his judgement is similarly misguided.
What I think is that he has been very adept in having a bold vision, using his showmanship to get the funding, talent, and visibility to get it off the ground, and then leveraging that into a feedback loop that bolsters his credibility for the next bold vision. I think it's very admirable that he has executed that playbook so well for so long! (And I think it's good for society that Tesla and SpaceX and Starlink and Neuralink exist, and I certainly appreciate his role in that.)
But I think his track record for things that aren't part of that playbook is pretty bad. Buying Twitter was not a bold vision, it was dumb very-online pettiness. And there's now a history of specific business decisions that seem to come directly from him, which I think have just been bad. Not bold visionary risks that didn't work out, just foreseeable bad outcomes from bad, impulsive, ego-driven decisions.
So sure, next time he's spinning up something visionary in AI or biotech or energy or who-knows-what, I'll pay attention and suspend my disbelief. But on the boring day to day executive decision making that every company has to do, I think he has earned less credibility than most (maybe all) leaders of businesses of similar scale.