Hi there!! Here is my $0.02...
I am a new nurse. I know it may sound cliche but... nursing does take a special kind of person. If you were to change majors to nursing you would need to start off with completing your nursing school pre-requisites. The most important classes that you MUST do good in are Anatomy & Physiology and Microbiology. You also need to take a bunch of general education (English, Psychology, History, Math etc.) These pre-req's can take about 1-3 years to complete depending on if you go full or part time. You also need to take Biology and Chemistry in order to advance to the A&P and Micro classes. TONS of science classes if you like science! But for me personally I LOVED learning about the human body. Then you need to apply to Nursing School...at either a university or a community college.
The above poster did great about differentiating the different roles of the healthcare team (RN, LVN, CNA etc.) If you want to become a nurse it is not necessary to become a CNA first, but it will definitely give you a great foundation for hospital nursing. I never worked in a hospital before nursing school.
Oh yeah and about the "gross" stuff. It comes with the job. Especially if you work bedside nursing. I empty bedpans, commodes, clean and change incontinent adults. There are also CNA's to help with this, but they are not always available. I do dressing changes and see some crazy looking wounds, and have worked with a tracheostomy. This stuff can be gross at times but I guess I am used to it. You will find that nurses can talk about the grossest things while eating lunch and not get sick!! LOL
Well there is my two cents for what it is worth!! I am the only nurse in my whole entire family, I just decided after high school I want to become a nurse!! Nurses are educated professionals...I am so happy with my chosen career. It is stressful and rewarding at the same time. If you have an "itch" for nursing...then check it out. Do some more research into the field. There are tons of opportunities for nurses and you can specialize in an area when you find your niche. GOOD LUCK and welcome to allnurses!! Be careful because you may just become addicted to it!! LOL