It comes down to the individuals involved, not the job.
You either make it work, or use it as a convenient excuse for the breakdown of your relationship.
We all have friends who spend time away with work, sometimes weeks at a time, and their relationships and families are just fine thankyou.
Then there are others that aren't so lucky!