The excitement around space exploration company SpaceX leading into its initial public offering was only matched by the disappointment that happened shortly after its debut.