Now, I will admit Im a bit of an Elon Musk fanboy but very seriously speaking, Elon Musks success with SpaceX has boosted the space race once again. Allthough Musk isnt taking SpaceX public there are still other companies you can invest in with amazing plans for space.
https://www.inverse.com/article/37977-investing-in-spacex
https://www.investors.com/news/technology/space-industry-booms-billionaires-like-elon-musk-funding/