Prior to the Twitter situation, lots of people thought of Musk along the lines of being a new Henry Ford (American industrialist) or being a real life Tony Stark (Marvel's Iron Man tech genius character). With the successes of SpaceX and Tesla, many thought he could do no wrong.
Musk has certainly done massive damage to his image, and many well known business experts are calling him out for massively overpaying for Twitter, his management style, and even for trapping himself into the situation in the first place.
edit: Ford's Twitter, if you will.
This may have been true a couple years ago, but with the constant delays of the Cybertruck, not to mention the constant lies about FSD [0] have taken down that facade.
[0] In the mid 2010's, I used to be generous about Musk's FSD claims, thinking he just really doesn't understand how hard it is. After a couple years of that, I thought "Eh, he's just trying to drum up investors, no different then any other company being aggressive about timeline claims". But at this point, it's straight-up lies. We're still years away from FSD being usable in city streets, and there's no way Elon doesn't know this, but he still spouts the same bullshit. At this point, his FSD claims are fraud, as far as I'm concerned.
No, people in the public sphere do not think Musk is doing OK with Twitter. They thought he was doing well when all they saw was him on stage taking credit for Tesla and SpaceX's engineering work.
Now he is at a company where he is dictator supreme, his actions are far more public, and nothing has done more to tear away the illusion of his Midas touch. He's muttering about 'woke mind virus' due to boos at a Chappelle show where the audience were laughing at a half hour of LGBT jokes.