worrywart, your community college should offer a 2 year nursing program. This will give you your ADN, associate degree of nursing. With this degree you are qualified to take the state boards- NCLEX exams. You will be an RN with the 2 year program. If you want to go on and finish your bachelor degree you can. Some people finish right after getting their RN. Others wait to finish and others never bother. So you should not be looking at 4 years. You can get your RN in 2 years and go to work as an RN. You need to have prerequisites completed to get into the nursing program - anatomy and physiology, microbiology, maybe math (depends upon what you have taken already). Many 2 year programs have a waiting list so you may have to be patient.
Hang in there. If this is what you want to do you need to keep trying. I hope you will consider all your options, even the community college. I went to a 2 year program at the local community college. It was difficult. I did little else but study during those years. My social life was on hold. I wanted and needed to get through the program. You make the sacrifice but the rewards at the end are worth it.
If you need more info you can pm me. Keep the faith. You can do this!