Not at all. He did lose a lot of money recently, but most of that is "on paper" - he still has at least that much left over. I'd be more than happy to have his problems. He's in a valley right now, but his batting average is very high.
Elon Musk is strongly outspoken, and has strong vision, communicates the vision, although it can change in a day. But at least everybody in the company (or rather everybody on Twitter) knows the plan to execute on.
When Sundar speaks he speaks politically, so that he can never be wrong (at the same time if I just watched his talks, I couldn't even know that I'm at a search company).
He seemed to do a pretty good job with that at Tesla/SpaceX, but I’d argue he’s really dropped the ball at Twitter. No one seems to have any idea what “Twitter 2.0” even is supposed to be.
I agree that he really dropped the ball (I moved to nostr because of him not allowing links to nostr). I think it was because he lost tens of billions of dollars because of the amount of leverage he had, the market downturn, and advertisers dropping so much because of the political uncertainty that Elon brought (advertisers are risk averse by default).
I think all of us have an idea of what social media should be compared to what it is now (looking at what my friends and people I'm interested in it are doing), but it's not compatible with the amount of advertising revenue that needs to be generated to justify a $40B valuation.
There's a deep conflict between the value provided to the users and the value created to advertisers, and Elon highly underestimated that conflict, so now he's (and Tesla investors are) paying the price.
To play devil's advocate (I'm no fan of Google in any way), but this is also how Elon Musk operates, and it seems to be going well for him.