I'm sorry you had that experience.
It works for some, it doesn't work for others. It all depends on the woman involved. I think the one left behind has a harder time, but if you let them know you care, it can work.
I've been married to a Nukeworker for 7 years now (together for 9 years), and most of the time, he's been gone during the week and home on weekends. Right now, I get to see him once a month. It's tough, don't get me wrong, but it works. I have a good job (it helps to get good benefits), we have a house, I have good friends. I've learned to really enjoy it when we're together, and to take care of things when he's gone. It helps to have the same cell phone plan!