Ha, I'm also 40 with a DH who's nearly 34...great innit? 
I think it's a tough situation because, of course, there are usually benefits that come from having a partner work away sometimes -- a bigger salary, a nicer house. And it must be hard to not always be happy with the situation, because it comes off as ungrateful.
But I've noticed on these threads that the usual responses are -- suck it up, he's providing for you, it has to be this way so deal with it, he's lucky to have a job, etc.
I just don't think that's fair. It's as if, as long as a man is 'providing for you', you should just stay home and be grateful. Never mind that you are 'providing for him' by raising his children and running the home. And never mind that many men are able to provide for their families by taking jobs that don't require working away, even if that means a lower standard of living.
It would be one thing if you were some greedy thing pushing him to work away for the big cash and then complaining about it, but it doesn't sound that way.
I'm not sure I could ever forgive my DH if he chose to work away rather than be there for the birth of our child. I mean, I guess I would have to, if I wanted to stay with him, but it would be really hard.
I do have a feeling though that things might really improve a lot overall if the two of you could get past this -- and I say the two of you because I think he needs to acknowledge that, however beneficial his working was, it still caused you a lot of grief that wasn't, really, necessary.
But I bet things will get a lot better when he's working out of the home. My DH will start doing so next month and I can't freaking wait 