Decisions and guidance

I recently transferred schools thinking I had a better chance getting into nursing school, but I didn't... It seems like it got from bad to worst because earlier my freshman year I failed two science courses( what was I thinking trying to take them both at the same time) with that being said I was not allowed to be in the BSN program at the other school.. So it has left me to the decision to either change my major or go to a community college. I have scheduled to take the compass test nov.8th (delta community college) they admit students in May of next year.. I am a junior and really getting frustrated because I have been going to school for 3 years and I am being told that I have to change majors or either drop out the university and go a different route to becoming a nurse. This is something that I really want to do but I'm just scared of making a step because I'm afraid that I'll be turned down again, the third time. I want to get a degree in something, but I also want to be a nurse. I just don't want to drop out this university and go to a community college having going to school for 3 years and getting a different major may take 2 more additional years. I just turned 21 and people say your young but really I do not want to be in school forever CAN SOMEONE THAT HAS GONE OR GOING THROUGH THIA SITUATION PLEASE HELP ME