Whatever he turns out to be, this tech is going to be there in the head of those people working at SpaceX. Should it go bankrupt later, other investors will hire them and they go forward.
Musk is … unique. Let’s say. But he is very good at organizing companies for a relentless push for the results.
Treating employees as burnable resources isn't very good business, though. He's "good at" long-term dysfunction for short-term gain. Through that lens, I wouldn't be surprised if he decided to juice Twitter's MAU metrics by turning the place into a trainwreck.