There’ll be people more qualified than me to answer this, but its a hard thing to answer as it depends on your background, is there a discipline you are better at already, how much time can you realistically allocate towards training, etc.
In terms of juggling the various commitments, its a matter of getting done what you can, when you can (eg when kids are asleep). But that’s just what works for me - not much more to it than that. If you’re committed to your goal you’ll find a way to make it work.
Only other thing I can add is a coach is valuable even if training solo, be consistent and have a good diet.