CNBC spoke to people who’ve worked with SpaceX’s president and chief operating officer.