Nursing school (plus the first year of working) can be all-consuming. I will always strongly suggest doing it before having kids. Nursing school will probably include weekends, late nights, very early mornings & loooong days. Your partner/family will have to pick up a lot of slack taking care of the children. I know so many people that were CNAs or LVNs and had kids with the plan of going back to finish RN school "someday" but never do because kids take over your life. Many do go back, but it's a big challenge.
Also, be realistic about the timeline. You said "nursing will take a few years". If you haven't, talk to a nursing counselor to see what classes you need and how long it will realistically take. It takes most of us more than a few years to get our RN, and with impacted programs, it's hard to get in.
I totally agree with the advice about doing CNA training.