The SpaceX listing, widely seen as one of the largest public debuts in history, lifted sentiment even as related space stocks declined