Should I drop out and go to a community college?

Hey guys. I’m an incoming freshman who is about to attend the university that I have always been pressured to go to, and I THOUGHT I wanted to experience it. However, the degrees that are “worth” receiving are basically all STEM related. I even chose Chemistry as my major because I thought it was interesting, but is it really something I want to have a career in? Ehh, nah... I only applied to the university in the first place because my counselors and family always told me that it’s a great opportunity to receive a bachelor’s degree. But now that I have properly researched the jobs I can get straight out of university, I realized that I don’t have to go through all that work to get a rewarding job. I could literally just get an associate’s degree for jobs that a person with a bachelor’s degree could also get, with pretty much equal pay. I’ve been looking at all the medical programs in some community colleges, and they honestly catch my eye more than the programs/majors at my university do. The university I’m attending is fairly prestigious, but I really don’t think it’s worth the trouble and student loans. So I’m at a dead end here. I’m not sure what to do. Should I just be miserable for 4 years and maybe get a job that has equivalent pay to one which requires an associate’s degree or just drop out right away? I haven’t done any classes yet, but I am enrolled in some special summer classes, and my orientation is tomorrow. I just feel really discouraged at this point thinking about my future and it’s giving me so much anxiety. I am extremely fickle and don’t know my career path at all. I just wanna drop out, but I don’t want to disappoint my family either.