In my 2 year ADN program where I started out, I didn't have that much exposure to a large variety of things. You get just what you need to begin to be a nurse in nursing school, what happens after that is the real test.
I remember vividly, my OR experience, when they were prepping a young 21-yr old man for a gall bladder removal, they started the anesthesia, and he went out, and as soon as he was asleep, the nurses whipped off the sheet covering him, and he was laying there totally exposed while the nurses busled around getting things ready, and while the docs scrubbed. Meanwhile I felt so shocked, and definitely knew I would NEVER have surgery at the hospital I worked at!!! LOL!
But, in nursing school, it's only a few weeks in each area, not the rest of your career, and not every day, usually 2 clinical days a week, so all told, your exposure to things is limited in nursing school. And, if you get sick, and hurl on your instructor's shoes, she/he probably won't make you suction again anytime too soon!!
Is it an emotional job?? Absolutely! But, again, not to sound cold-hearted, you will learn what you can and can't do. I went thru a lot of training to work on a cardiac pedi ICU, saw a lot of kids suffer and die, and it ripped my heart out. I will not do peds anymore. Yet, I love working with the very elderly, but when they die, I can know I helped them to be comfortable, or helped them to verbalize their fears. I think I would like to do hospice, but again, watching young people die of cancer is so hard.
There are so many things you can do in nursing, getting the exposure in nursing school helps you to decide.
Why not work as a CNA in a hospital or home health agency to get some idea of what the daily grind is like, and ask to work on a variety of floors, to float, so you can see what it's like.
Good luck w your decision.