I'm terribly afraid I might fail college again...

I finished the semester with a D+ and a withdrawal, so I'm going to lose financial aid. This is my second attempt at college, and I just can't seem to lock in consistently for years straight. I made it two years with straight As at community college and then transferred to a prestigious state university. Now after my third semester I have two Ws and a D+ on my transcript. I'm so disappointed in myself. Do I give up and go to trade school? Do I give college the middle finger and throw a hail Mary to try and make it as a musician since I love music more than math and science? Do I go back to working dead-end, menial labor jobs and tell myself I'll be okay so long as I can pay the bills?

I just don't know anymore. It may be a sunk-cost fallacy, but I probably won't give up on college since I've made it this far.