I don't think I got any really negative feedback when I changed majors from Mass Communication to nursing, but everyone asked me "What made you decide to be a nurse?" My aunt on my mother's side was ecstatic: she has her BSN, loves nursing, and is ready to have someone to talk to about medical stuff that no one else in the family understands.
The only comment I received that I took as being negative was from an aunt on my father's side. She said, "So you're not going to finish college?"
My boyfriend went through an ADN program for a year before he decided it wasn't what he wanted, and I remember him telling me about 2 years ago (before I decided to change my major), "Don't ever be a nurse. All those bedpans..." Of course, now he's totally supportive of my decision, especially since my job will probably be supporting both of us until he finishes school.
Anyway, I have realized that this kind of negative thinking is still common among family and friends who have no idea that nursing has changed since Florence Nightingale. You just follow your heart and trust that God has led you to this career change for a reason. You'll be a wonderful nurse, and eventually everyone around you will realize that, too. Especially if they come into the hospital during your shift.
Best of luck from a fellow Texan.