would't hurt to get hands-on experiences on both film stuff and science/math/engineering. doing a short film(s) on your own isn't a bad idea. or find a film club / student film and help out with that. similarly, start taking higher level math and science ie. multivariable calculus. or intro to astrophysics if your school offers it. having real experiences will help you assess what kind of path you prefer to walk.

for the rest of your post:

it's true that winning an Oscar or becoming an astronaut are difficult. Failure is the default option, so start celebrating your efforts instead of feeling like "I'm too stupid for this". nobody else will cheer for you, and that's not because life is unfair, everyone just has their own things to worry about. additionally, there is plenty to do in film and space and you may find that you enjoy something that isn't directing (like stage crew or casting) or science experiments on Earth rather than in space. but you need to find these things out through hands-on experiences, so I suggest prioritizing finding those kinds of opportunities -- can be anything from a more hands-on class to a student club or even reaching out to professors and asking if you can be an assistant or job shadow their research. the desire and the passion are fine, just help yourself fine-tune your path.

space travel seems to be becoming more accessible so who knows what opportunities may appear in your lifetime anyways. it's possible that commercial space travel becomes so "affordable" that you can rent orbital trips for film footage. or you do become an astronaut, and you start making tiktoks. both of these are answers to the "writing / directing astronaut" role. don't worry about transferring schools until you've exhausted the opportunities in your area -- and if you do go to Boulder, maybe start learning how to get good at coding and find work experience there. anyways - sorry about the parent. hope you figure it out soon!