Tesla in 2024 is certainly succeeding in spite of Elon. From firing the supercharging team because he had some kind of mental break to the tens of millions of dollars and engineering hours wasted on the cybertruck instead of another practical vehicle he clearly isn't contributing much to what is at this point a matured company that doesn't need a maniac (for better or worse) at the helm.
What you say makes sense, but this isn't the first time he's acted this way at any of his companies and they're all still going well. At some point you have to admit either his methods work or there's more to him than what you the general public see.
Elon was fired from Paypal. He didn't know the platform, didn't really bring much to the table, and just pissed off the board. He got rich because he got to keep his stock. So I'd say yes, Paypal succeeded in spite of him.
SpaceX is doing well because of Gwynne Shotwell the COO. She's been able to keep Elon out of the weeds and basically at arms length. Let's not forget Tom Mueller who basically created the entire propulsion platform.
When Elon gets involved he makes silly things like the Cybertruck. Completely useless, poorly engineered, and overpriced garbage.