If I were you I would also BELIEVE I can get into a school I can afford and graduate. IMO if you already think you may drop out or fail out, you will. In addition, if I were you I would retake classes if there is no penalty to raise my GPA.
I know some people who lived in an area that is hard to gain acceptance so they moved to a less competitive area in another state. They worked full-time to live and gain residency. They attended school part-time to improve his/her GPA and were recently accepted into Nursing school. This is something I would consider if I were you and it is feasible.
Lastly, if I were you I would NOT take out a lot of student loans or go into a ton of debt to get through nursing school. Nurses do not get paid well enough to pay off a ton of debt! A few thousand dollars maybe. But most people take out the $20-40,000 for tuition and take out an additional $20,000-30,000 to live on! That is insane!
Especially since you must pay the loans back even if you do not receive a degree or a good income upon graduation. Not to mention, most say he/she will pay off th loans before he/she purchases anything else, but it does not happen. As for reimbursements and bonus programs, they normally only pay $10,000 toward school loan debts, which is paid over a period of 3-5 years ($20,000 if you are lucky).