Your vision of bedpans, bodily fluids, backbreaking on your feet is a pretty accurate description. Nursing offers much more, but you have to pay your dues with the training process before you get that license and the dream job, so includes all of the above.
If you don't feel it in your heart at 47, it would be a tough road to compete with the youngsters just out of high school, going into nursing. It takes a lot of hard work, dedication, hours and hours of study, writing papers, and once you get through school, you will get your "clinical skills" with basically "on the job training". Most Nursing programs do not prepare you for the level of responsibility, high stress staffing demands that you will be thrown into at the get go.
I am a 44 year career RN, Oncology Certified for 24 and still love what I do, with great satisfaction in helping people. Early on in career, I thought pediatrics would be great, and thought a camp nurse job would be such fun. What you want and what you get can be very different, it was the worst job ever. Ha Ha!
My niche has been IV therapy, infusion specialty in Oncology, but have experienced nearly every facet of nursing, from being a nurse's aid in my teens, to being a director of a small town hospital, medical surgical nursing, emergency, surgery, labor and delivery, oncology clinics, home infusion therapy and have loved practically every job I have had. But believe me, you have to take the good with the bad, the clean with the dirty with every walk of life, with the nicest people you will ever meet to the very dregs of society. You can't get through Nursing school without exposure to all of that.
What ever you choose, whether nursing or something else, whatever you don't like and want to change, remember, you will just exchange one set of problems for another, so you need to decide which problems will be the least trouble or what you want to put up with. That includes family sacrifice, weekends, nights, holidays, missed events, overtime.
If you are looking for a dream job with good pay, you have to work your way from the bottom. An associate degree program would get you to a Registered Nurse License in 2 years, and a BSN at least 4. Some places will not hire without a BSN.
At age 47, just thinking about becoming an RN, you are looking at considerable time before you get the "big bucks" With a husband in Medical School, I don't envy where you are, and if you don't feel "drawn to" or passionate, I wouldn't recommend it. As far as "family friendly", unless you want to be a phone nurse or paper pusher, a school nurse job might offer better hours, and MAYBE fewer bodily fluids but usually not the great salary.
There are already enough "nurses" in the field that treat it as a "job", not a passion. I know plenty of them who do it because it does pay well and offers security in having a job, but they hate the hours, the sacrifices and don't want to give anymore than what it takes to get by.
Though old enough to retire, I am thankful I still love the career, still look forward to going to work, love the personal growth and satisfaction that I am doing something with such great purpose.