I've been on this path for a couple years now -- also a mom, 43, leaving an unrelated career. Community college has been an awesome transition opportunity. I still work part-time and take a class or two each semester at night. But they are meaty classes with labs (e.g. a&p) where studying almost a full-time job in itself. Coming from a creative field, simply learning *how* to study science has been a huge thing for me to figure out, so as an engineer you probably have the kind of brain that gives you an edge on this. If your kids are still young, as mine are, juggling their expectations/schedule with your spouse and household will also take some figuring out that can take time and have many ups and downs.
Maybe it's where I live, but it kinda surprised me that getting into the community college nursing program is actually more competitive than some of the more elite BSN programs. Everyone is trying to make As and things get pretty intense (though non-science pre-requisites like psychology have been insanely easy and most people in those classes are half-asleep).
Be sure to go to open houses for nursing schools and start making a spreadsheet of pre-requisites of each (there may be some differences, which can be frustrating if applying to several!). Just be open to jumping in and meeting people in your classes, ask them about their path too. Many are probably currently in the medical field as LPNs or similar, and have great insights. That's helped me way more than school advisors and stuff. Also, it can be very affirming to meet other "mature" students and develop a bond.
Anyway, best of luck! I'm currently waiting to hear back from nursing programs after finishing my pre-requisites and never thought I'd even make it this far. But it's been such a fantastic experience that's really energized me and made me excited about the future -- especially after kinda petering out in a career that made me feel "old", unappreciated, etc, at this point in my life.