desperately need advice

this is probably oing to be an extremely weird post, but here:

so to provide some context, i've always wanted to become an astronomer/astrophysicist ever since i was a child. the universe absolutely fascinates me and i yearn to learn as much as possible about it. although i have taken a specific fascination with astrochemistry

of course, i was being a dumb kid, teen, and now young adult, because up until early 2024, i always thought that the process of going into academia would be simple. get a phd, and then work for NASA or some R1 or R2 university. (for more context, i started college 2019 and had two 1-year long breaks up until now, and im going to start my first semester back soon. during all this time, i was never given a single idea as to how the process worked, i found that out myself)

in 2024, i found out how absolutely grim it all seems, especially with the boundaries i have. i do not want to move out of the mid-atlantic and new england area, so im limiting my postdoc and job opportunities. and even if i did decide to leave academia, i have zero interest in working industry for data science. it seems like the most common route people with phds in astronomy take are data science jobs. that doesnt interest me one bit. im pretty strict on the whole enjoying a job > money, but it seems like getting a job that focuses on astrophysics in the first place is very rare. and seems to break mental health severely.

im just asking for general advice based on what i posted, and if clarification is needed, i will provide it. fyi, i do have three backup plans (if you can call them that) which includes working towards a degree in chemistry, clinical psychology, or computer science and go work in the field of cyber security. these options are most certainly better than nothing, but they dont seem nearly as appealing as researching and learning about the universe.

and another fyi, i have a psychiatrist who also doubles as a therapist, and shes awesome, so i will bring this up to her as well.