Retail investors are flooding into space-themed ETFs ahead of the SpaceX IPO, including Tema ETFs' NASA, which offers direct exposure to Elon Musk's rocket company. ETF experts say the uptick in interest in space investing could mirror the early AI investing wave.