SpaceX is a success despite Elon. Maybe setting an extremely lofty goal helped somewhat but Gwynne Shotwell and all the actual engineers at SpaceX deserve the credit for their success.
I agree that the team deserves most of the success. I think that's the case in general. At best, a CEO puts down good framing/structure, that's it. ICs do the actual innovative work.