Broaden your search to include community colleges, BSN programs, and ABSN programs outside of your immediate area. Look at the admission criteria for each program and how closely you align with it, and what additional coursework or experiences you may need, and how closely you align with a programs' critera (are you going to be a shoe-in based on the program's criteria or is it more of a long-shot). It helps to make an excel spreadsheet.
Also lay out the cost of tuition and fees for each program, as well as cost of living in the area where the program is located, current income, likely income as an RN, and map out total costs of going to each program - including cost of living, and factoring earning information (current, how much you'd have to cut back to school, over time, and change in salary), and see where true cost ends up.
Now sort through it and figure out your own priorities - is it more important to get in right away? to save money? to stay in your current location? and apply to programs based on where they rank for you.
As for a CNA course - I don't think it is required to get significant work experience as a CNA before school (though I think it can be helpful), but more and more programs give extra admission points for completing the training. Other programs don't care if you have the liscense but want to see that you know what you are getting into and working as a CNA is a great way to show that you understand what working in healthcare really looks like, aren't afraid of hard work, and aren't going to freak out in nursing school the first time you are asked to wipe up poop or give someone a shower. Nursing programs
want students who know what they are getting into and who aren't going to drop out of the program or quit in their first year of two of being a nurse because the reality of working as nurse is different from what is seen on TV or understood in pop culture.
My thought on CNA work is to look at your current finances - how do CNA wages compare - if it is going to be a significant decrease in wages and ability to support yourself, probably don't actually work as one and look at other ways to get healthcare exposure. But if you are working a relatively low paying job - might as well transition to one which will provide work experience that counts for the profession you are trying to get into.