SpaceX FOMO is officially over. Space stocks across the board are getting punished. Investors seem to be having second thoughts about the lofty valuations in the sector, an analyst said.