I'll side with Devnation.
I've only been a nurse for 3 years, and having spent my entire adult life never wanting to be involved in healthcare, I now wish I had looked at it more seriously many years ago.
Some of the things that I like about the field of Nursing: It is an in-demand job. Pick a specialty, and even some that you would not have thought of for a nurse, and you'll find job openings for Registered Nurses there.
It's an extremely portable job. When you get a wild hair and decide you've always wanted to live in Rhode Island, it's a very simple matter to relocate and step almost seamlessly into the new job.
It pays well. After almost 4 years of experience as a Paramedic, my very first RN job paid $10/ hr MORE than I earned as a Medic. With just an Associate's degree (I realize your program is BSN), a new nurse in my area STARTS around $50k/ yr; more at the hospital right in my town.
It's very flexible. Do you want overtime, or only sip from the time-clock? In many cases, the choice, quite literally, is yours.
Oh, the variety! Especially since you'll enter as a BSN nurse, when you decide that you want to change specialties, even to something radically different, after your first job it's all just on-the-job training.
To your concerns: I once had to intubate a seven year old boy who had been involved in a car crash. It was very difficult for me: he's a little boy! And, he was just about my own son's age. I had to dissociate myself from the emotion of it, and think about him simply being a body that needed an airway. Whatever the tasks are, and especially while you're in clinicals, they won't be terribly complex or scary; look at them as tasks that need to be completed and simply complete them--competently and professionally.
Just yesterday I had an 11-month old baby that needed an IV. I'm very good at starting IVs, and I also knew that I had a partner who is God's gift to little baby IV starting! So I let the family know that I was going to ask my partner to come help, and away we went. If you're friendly and honest with your patients you'll find that almost all of them (and their families) will relate to you being new--or a student--and will be patient while you "practice" on them.
Finish your schooling. Study hard, become a professional. And then find a slot in the extremely broad, amazingly varied field that is Nursing that does interest you. It's completely okay if it is not bed-side nursing.