Marriage is about TWO people. Good marriages are all about give and take, by both sides of the equation.
I've been fortunate to have a wife that understands my passion for aviation as well as the ins and outs (and ups and downs) of the industry.
When I lost my job after being furloughed, we moved for my career - in part because it meant more overall income and a better quality of life for our family. The down side was that she had to give up a decent job for something that is a lot less desirable. While we like our current lifestyle and surroundings, I know that there will likely come a time when my wife wants to move on in her career. I'll support that and look for a new job, as long as it doesn't put us into financial jeopardy, or put undo strain on our relationship (such as the two of us living on opposite sides of the country).
The truth be told though, these days very few aviation jobs are worth relocating the family for (particularly regional or entry level jobs). This is even more true when the non-flying members of the family are already established in successful jobs that often bring in 3-5 times what a regional FO makes.