His fans are supporting the savior complex because he's virtually the only one who is actively making a better future in a significant way. While everything else is crumbling. They forgive the mistakes he makes given that context.
If Tesla, SpaceX, Neuralink, TheBoringScam etc. disappeared overnight, consumers quality of life would not be affected one bit. It's very similar to Ferrari or Tiffany&CO going under..it's meh. Contrast that with Exxon, Saudi Aramco, Google, Microsoft, Amazon, Walmart, Costco, VW, Daimler...
There are unknown private companies such as Vitol selling 300bn dollars worth of products per year. Do you know Vitol? No? Well why would you...the CEO isn't constantly shitposting on twitter.
Musk is like Donald Trump, Bill Clinton, Hillary Clinton, Joe Biden etc. What you call success is what people who don't fall for cult of personality call "being a BS-seller". Convincing fans and supporters that they are some sort of hero against dark forces
When I see how small of a subset of the population actively use Twitter, or have even posted once, compared to the political power it has, it's hard for me to argue we're better with it around.
Having all of those people, plus pretty small proportion of "regular people", can make it really feel like everyone is on twitter. But the many of the heaviest "regular people" users are often actually those who are trying to promote some agenda, which can be one that is very not-representative of the public at large.
But this feeling of everyone being on there, means that if a small group of vocal participants who have an agenda can get something trending, especially if they can do with with only limited pushback from other groups, it makes it feel like something everyone cares about. Worse is that the algorithm tends to promote extreme views a lot because they get more interactions.
Now the influencers, politicians, celebrities, journalists, etc are not very much not immune to mistaking an artificially algorithmically inflated hot take by a tiny but vocal minority on twitter as representing a consensus of a huge group of regular people on twitter. The next thing you know, the current twitter outrage is on the news, and your favorite celebs are probably talking about it both on and off twitter.
This can cause people who never would have seen or interacted with the twitter controversy to become involved. Obviously if the news is talking about it, this is a big thing that a very sizable chink of the population is feeling, right? It could not possibly be not something initially stirred up by at most few hundred extremists of some form on Twitter, right? Wrong.