Thinking of becoming a nurse

I am not currently a nurse, but I'm currently in school getting my graphic design degree. However, I keep thinking about nursing. My friend flat out laughed at me when I first told her about my thoughts of doing so. She thinks I'm too much of a priss. Blood and gore do not bother me, but I am honestly just clueless at what nursing has to offer. Is it emptying bedpans and cleaning up vomit, or is it comforting patients and helping doctors? What's the difference in CNA, RN, etc.? Do you get used to the gross parts of the job or is it something you are born with? I love taking care of others and feel I have a compassionate personality, yet I feel like I can be objective at the same time. I don't let my emotions get the best of me. I like graphic design, but I daydream about being a nurse. I don't know anyone who is a nurse so it's hard for me to get any advice. I would love to work in pediatrics, pedicatric cancer or at the Shriners Hospital. I hope someone out there can give me some advice. Thank you so much!!! :)