SpaceX's CEO is Gwynne Shotwell, and she did not almost become CEO of Apple.
Day-to-day leadership is performed by Gwynne. Musk is founder, majority shareholder, CTO and CEO. According to Musk himself, he spends the majority of his time at SpaceX as engineer, letting Gwynne lead the company.