So, you screwed up at a community college. That is not a very good way to show any 4 year college that you have what it takes to get through nursing school
---failing an accounting class, "unofficially" dropping an English class & getting an "F" and passing a speech class, when those were the only 3 classes you took in one semester looks pretty bad.
My question is, who was your advisor that recommended that you major in accounting? What subjects did you like in high school? Did you do well in science & math? If not, you're going to have a hard time getting through the nursing curriculum. Because you have to still take pre-requisites, it leads me to believe that you did not max out on science classes in high school, and you are at a great disadvantage because of that. You really need to speak to a college advisor (or even go back & talk to one of the advisors in your high school) to explore what career options are good for you. If you can't stand the sight of blood or cringe at the thought of a syringe & needle, nursing is not the place for you. The nursing curriculum at any college is rigorous and demanding. You will have to buckle down in a big way to get through 4 years of it. Nursing has minimum required GPA's to stay in the program, too. You can't skate along with C's and expect to do well on the NCLEX exam. College-level anatomy & physiology, organic & inorganic chemistry, microbiology & pharmacology are not easy courses, and you will likely have to take a few of them together. They will be far, far more difficult than the English, accounting & speech classes you took that you ended up failing.
How do you "KNOW" it will be rewarding? What have you based your decision on? The stark fact is that nurses are having an extremely difficult time finding a job, especially if they get associate's degrees. You can forget about getting a job at any NYC hospital without a bachelor's degree. Many teaching hospitals in Nassau & Suffolk are the same way---they want their nurses to have bachelor's degrees. If you can't get a job, it is not going to be "rewarding" at all, especially if you have to start paying back student loans 6 months after you graduate.
My advice would be to make sure nursing is definitely what you want to do before you waste money on something you come to realize you don't like. Take some time off, get a job & think about it. Talk to an advisor. Talk to people that are currently nurses & ask them what they do on a daily basis.
Don't just jump into something haphazardly because you blew it in your first attempt at something else.