Musk seems to understand that money is a means, not an end. He doesn't want money for its own sake. He's got so much money that if he just plain lost $44 billion between the couch cushions he probably wouldn't bother looking for it.
Musk wants the power and prestige that come from setting the policy on the world's most influential platform. He thinks he's putting the world aright.
I think he imagines that everybody else will come to see it his way. He's hardly unique in that: most people believe that the world would be better of if we all just did things my way.
Now... he also seems to be just plain failing at that. He doesn't seem to understand why people paid attention to Twitter. He may not care if he harms the company financially, but if it's also costing him influence, and making him look stupid, he really is worse off.
I'm sure he'd ask me if I'm so smart, how come I ain't rich. All I can answer is that time will tell -- and maybe not even then. He could well succeed even if he's wrong and I'm right.