It's hard to understand how SpaceX can be such a success while Cybertruck and Twitter are such a shit show. (Let's ignore Hyperloop because he admitted that was always an anti-rail spoiler.)

Based on his Tweet history, he comes across as astoundingly immature, thin-skinned, and easily distracted.

He has: accused someone completely innocent of paedophilia for random reasons that are hard to fathom; denied that Covid was a problem; tweeted like a teenager about womens' boobs and limited math skills; lost at least 75% on his purchase of Twitter; suggested a literal dick measuring contest with Zuckerberg; claimed he was going to sell 10% of his Tesla stock to alleviate poverty and then awarded to it to a trust he owns; cynically hyped Dogecoin and (arguably) Tesla...

And so on.

I suppose someone like that might also be a genius rocket engineer. But if he is, it's quite a niche talent that doesn't seem to have transferred to his other projects.

His speciality seems to be leading companies that solve tangible measurable hardware problems like "cheaply launch orbital rockets" and "make commercially viable long range fast electric car" (making cheap underground car tunnels is impossible so it doesnt really matter how good a hardware guy he is).

I don't know why you'd think being good at a domain would transfer to other very different domains. There's no reason to think an amazing singer would be a good mathematician, why should a hardware production line maker have good taste in truck aesthetics?