Go for it, beginner_chef! Having been a patient quite a bit for the last several years, I've met lots of nurses
and there are all kinds of opportunities. Several of the LPNs who cared for me were working on their bachelor's in nursing or getting additional training to become RNs, so once you're in and working, you can continue your education; sometimes the hospital will even help pay for your education, because there aren't enough nurses.
As someone else said, if you and hubby can afford for you to go to school full-time long enough to become an RN, your salary will be much more, but if not, you can work and continue to study later.
And once you're a nurse, there are lots of options - emergency room, medical/surgical unit, obstetrics, neonatology, surgery, doctors' offices, home health, nursing homes, etc. And if you get bored with all that
if you live near an academic medical center after you have some experience, you can be a research nurse.
The need for nurses will only grow as the baby boomers age, retire and need more health care. Good luck.