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.
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.
If I know someone as a Muskovite, I'm not going to talk about Twitter or Musk in front of them. They're just not rational or worth interacting with.
And I'm sure they think the same of me.
People are tribal. If you wanna get things done or work professionally with people, you ignore politics and focus on work.
I've literally met no one who thinks things are going fine.
Most people I've talked to about Twitter think Musk is doing okay and a small minority is just being hysterical.
Most people don't know or care about Mastodon and they don't trust journalists talking about Twitter. Most normal people checked out after the weekend Twitter was supposed to go down but didn't.