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.
It seems I have a hard time being attracted to someone unless I respect what they do on some level. Otherwise I would feel disdain for them. Which is not always pleasant in a relationship. Sometimes it's fun though.