Very interested in astronomy & space but I'm not a rocket scientist. What career could I pursue realistically?

Some of the questions you are asking have philosophical or theological basis and may never be answered in our lifetime. However, I can say this much: Careers in Cosmology, Astrophysics, etc. ALL require a good solid foundation in mathematics. There is just no way around it. There are multitudes of AMATEUR astronomers who have no degrees in physics or mathematics, but understand the CONCEPTS behind physical laws and theories without getting deeply into the math. These people make huge contributions to astronomy (e.g. the guy in Australia who was first to discover that Jupiter had been impacted by another body). Amateur astronomers are major contributors to astronomical research. So why not use your education to pursue one thing, but STILL follow your pion for astronomy? You don't need to be a "rocket scientist" to be an amateur astronomer. Just someone with a real pion for it.