As someone who wasted a four year degree with a terrible GPA, degree I didn't want, a FIFTH YEAR.... who is now going back to college for a degree I actually want with a good GPA, internships, etc- don't just keep muddling through!
Tell your family it isn't working, and you need to regroup so it isn't a waste of time and money. If you are able to be a good student when it is interesting, take ONLY gen-eds that interest you for a semester, drop out temporarily, or like you said, go to a community college Don't be me! Although I am happy, met my wife, etc, it was a MASSIVE waste of time and money, and stressful at the same time, and now I'm back in school but too old to enjoy the "scene" - I'm at a commuter school because of this. College was a ton of fun.... but as a young person you can still drop out, come back in a year or two, and get the exact same fun experience. (The fun comes from your peers, not your classes outside of the occasional gem)
In my opinion, unless you are VERY talented, you need a degree. However, muddling through college isn't the right way to get it, and there is nothing wrong with taking a year off or more. You were a good student, I'm sure you can manage to go back and do well even with a gap year. It might make sense to talk to someone at your current school, explain your situation, and ask about the logistics of pausing for a semester to a year so you can figure out what you want to do, interviewing adults in different fields, etc. Perhaps you can take one or two gen-ed classes and simply go down to part time at your good school, while boosting your gpa? School choice isn't everything, but I imagine if you are at one of the top schools in your area that there are benefits that you could use from being there.
Lastly, I know quite a few musicians who ended up in Computer Science, which is an in-demand degree. It may work for you, or not work at ALL for you, but consider it! (It's a hard degree, but not impossible)