I'm really nervous thinking about the possibility of being a working mum but also really excited as i really do love working and being a manager means more money for our family and i can really give our kids a good upbringing.
I'm a bit confused by this, are you working at the moment? That would make you a 'working mum' now wouldn't it? Or are you on leave?

I think certainly it can be balanced, it's not always easy but if you find working rewarding it can provide some balance in your life. Upskilling is a smart thing to do anytime, it never hurts to have new skills / abilities / qualifications. Raven's point is a good one though, the financial benefits of management aren't always equivalent with the pressure & stress.

If you are working now & you enjoy it & feel like you need more of a challenge, why not.