The SpaceX IPO will test the ability of Elon Musk to win renewed investor support for his ability to deliver grand visions that advance humanity.