Look if you ask a child 'Would you rather have a fulfilled mother or a stay-at-home Sylvia Plath ' they'll pick Sylvia Plath every time. But I think it's really important that children don't feel their parents' emotional lives depend on their success.
In theater or movies you see either 'I'm religious' or 'I'm an atheist.' I've never seen too much discussion of 'I believe there's a higher power but I'm hesitant to reach out to him because I don't know if I'm worthy of his attention.'