A Real Housewives executive has died in childbirth, leaving behind a baby boy and a 3-year-old daughter