I think I've messed up my higher education

Without taking A-Level Physics or Maths (which you could do in a year at a crammer, incidentally), your best bet is probably the Open University's "BSc in Natural Sciences (Astronomy and Planetary Science)", which has no subject entry requirements. It's part time and over 6 years, so I don't know whether that is a negative for you.

But I guess there is an argument to be made that, if you don't want to do A-Level Physics and Maths or take a foundation year in order to study Astronomy, then how much do you actually want to study it anyway? There's a difference between "I find that subject interesting" and "I am so passionate about this subject that I'm prepared to do whatever it takes to study it". And if the thought of doing A-Levels again or working in retail for a year in order to pay for a foundation year puts you off, then that probably tells how much you're really interested in it.

For a long time I wanted to study Music Tech, I enjoyed music and drama at gcse and went on to do music tech, drama and history at A-Level.

I did a year of Music Production at university but left due to various circumstances. Since then I've debated whether it's something I want to do, I enjoy it but I'm not entirely sure.

I've tried to narrow it down to subjects that genuinely interest me and excite me or things I think about all the time. One of which is space, it fascinates me completely and I love learning about it.

I'd love to study Astrophysics/Astronomy but pretty much every where requires and A level in physics or maths, and given that I've completed a year of uni I'd have to pay for a foundation year. Even then I'm not sure if it would be enough.

I'm just really unsure as to what to do with this. Even now I'm still a bit unsure as to what I want but I know that Astronomy is something I'm very interested in