Since the CC near you is mostly a vocational college, you need to find another CC. Can you move some place and work while taking part time classes at a community college, rather than stay in Missouri?
St Paul’s community college (in Minnesota) has excellent classes and if you work at least part time, supporting yourself, and going part time only (NOT FULL TIME) for at least one year, you’d be considered a Minnesota resident for all public universities. The transfer process from St Paul’s CC to U Minnesota Twin Cities is fairly smooth and instate tuition can even come with scholarships for transfers if you maintain a high GPA. The Twin Cities are thriving economically and they’re rather lower cost than other big cities. Finally, the area has a strong tradition in music due to the many Scandinavian immigrants (St Olaf, Concordia Moorhead, Luther all have strong choirs, with St Olaf being the gold standard - look the the PBS special) and the Twin Cities have LOTS of stages for you to perform, bands to listen to or join, etc, etc.
You can do the same thing in Florida - less of a musical tradition but warmer winters and a lot of strong public universities if you do well at community college.
Same thing in the State of New York but some areas aren’t quite thriving and where there’s an economic boom cost of life is too high for a part time low-skilled employee. :s