I think most cc students transfer to a 4-year school that they can commute to from home. Since finances are an issue I think you need to focus on affordability first.
If you’re graduating in May don’t take a bunch of cc courses over the summer. You’ll be burning through Pell dollars without a clear plan for finishing a degree. I think you need to explore local transfer options, see if they have majors you might like, then ask your advisor to help you figure out which courses might transfer there. Then as soon as you get to the 4-year school sit down with an advisor and create a plan so you know which courses you need to graduate on time.