Musk succeeded where his companies tried to disrupt extremely moribund or set in their ways industries.
SpaceX disrupted the space launch industry, which had not advanced at all since the 1970s. SpaceX really just picked up and ran with the idea of vertical landing reusable rockets, which was not new. Werner von Braun was exploring it for Saturn V back in the 60s, and Lockheed finally did it at prototype scale with the DC-X in the 90s: https://www.youtube.com/watch?v=wv9n9Casp1o (You can see at the end that the DC-X even does the same "hover slam" maneuver as Falcon 9 to land with maximum propellant efficiency.)
Tesla was similar. Auto manufacture itself isn't moribund, but old school auto makers always hated EVs and resisted doing anything serious with them. Tesla's rise was a classic exploitation of the innovators' dilemma by calling them on this and forcing their hand. Now that some are embracing EVs, Tesla is facing increasingly stiff competition but has at least carved out a brand.
Musk has not been particularly successful competing in less moribund industries. The Boring Company is kind of a flop. Neuralink seems questionable so far, to say the least. The Hyperloop, even if it worked, wouldn't be competitive at all with high speed rail on cost. It'd be faster and in theory more energy efficient but nowhere near enough to compensate for the added capital cost or complexity.
Now if Musk had created, say, a rail transport division of Tesla he could have absolutely disrupted rail transport which is another fairly sluggish moribund industry. Imagine modern unmanned trains (FSD on rails is WAY easier than on roads) with batteries to allow them to span un-powered sections of track and recharge on sections with third rail or overhead catenary wires. But that would have been a threat to the car market. Innovators' dilemma anyone?
My point is that Musk isn't superman... he just picked industries that were ripe for disruption and built teams that executed well enough to succeed.
Of his companies SpaceX is by far the most impressive in its own right. What Tesla did could have been done much much better by a "legacy" car maker if they'd been willing to disrupt their ICE business. Nissan actually beat Tesla to market with an affordable mass market electric (the Leaf) but didn't put as much heart into it. The result was okay but not nearly as cool as what Tesla did, especially in Tesla's glory days. (I own a Leaf and have no complaints, but it's not sexy.)