Morgan Stanley is emerging as a leading contender for a key role in SpaceX's blockbuster initial public offering.