Not sure if the person 'embarrassed' to drive a Tesla has looked into the history of other car companies.
It seems like the market will remove him from power soon, but the state could probably do it more efficiently.
As for the rest -- I don't think his choices are consistent with CEO leadership roles across the companies he's in. Twitter & Tesla have issues, Tesla's largely revolving around AutoPilot & FSD -- and eventually the market and/or Boards and/or his creditors will see a change in the risk and ROI of his leadership.
SpaceX seems to run pretty smoothly. Elon's halo is massive, and the lift he provided to Tesla and the EV market, in particular, can't be underestimated. But, IMO, there's no way this ends smoothly and happily, 10 years hence, given how he's acting in at least the Twitter corner of his field.
As for the previous leadership at Twitter and their censorship / collusion with governments -- yeah, that sucked, but it grants Elon nothing at all. Different shit, different day.
Another example of that btw is Julian Assange, he was praised as a hero until he revealed some corruption in the side of the 'good guys' since then he is a russian agent and evil....