Well, I have had fears of all sorts, and still have them, however, you adjust. There are so many branches of nursing to get into, that you may be able to avoid some of the things that make you squeemish. In nursing school, they told me to acknowledge the things that turn me off. For example, some don't care to deal with pediatrics, alcoholics, etc.
Time management will be a major issue; because they shove so much at you at one time, and it may be very true that you may have to place your family to the side; maybe begin to assign them chores to assist you, especially if you are currently working as well.
Nursing is not all about wounds, however, (especially as a practical nurse), you have to be trained to do dressings, and many of pressure ulcers are unsightly and smelly. There are venous stasis ulcers that can be distressing as well. I am not turned off by it, but there are many that are. But, if the empathy and the compassion is there, you may learn to adjust. What I keep in mind is "What if this were me, or my family member"?. You may also find that in spite of the best intentions, you may lose patience or become irritable. No matter what the Nightingale image was, we are human and have frailties. It doesn't mean you are less than a nurse, it means that you can accept that at times, we screw up. Good luck in your decision.