If you are going to a public college there may simply be so much competition to get into the few spots allocated to the nursing program that in your case it might make sense to look into transferring to a private college, ideally a local community non-profit, the cheapest you can find after factoring in any scholarships
and get your BSN that way. I would avoid for-profit nursing programs
that advertise on TV and radio, they are too expensive and can be unscrupulous. A private college usually has smaller class sizes and more individualized attention as well to keep you on course.
I drifted in a liberal arts program for years taking classes part-time and working part-time with no advisor ever contacting me about graduation. Don't get me wrong, I chose to explore different classes, it was a very fun time in my life both school and work, the best job I ever had! I finally came to the realization that a liberal arts degree would be useless to get a decent paying job and wanted to make more money than I was as a secretary. Then I decided on nursing as I had worked in an ER and saw the nurses at work and was impressed. I transferred to a small private college and it was night and day the level of assistance you received and the small class sizes. At the public university, the chemistry class must have had over 100 students in the lecture hall and then maybe 30 in the labs, while the private school it was much smaller class sizes.