Is there any hope for this relationship?

Long story short, a very good friend of mine sent me a variety of texts last night basically saying he never gets laid anymore, has not in his physical current home (been about a year), and says he's not sure why married, etc. This is very rare for him to open up or complain about anything really. He's a very successful engineer and great friend, teammate, etc.--giving almost to a fault.

Anyway, I've know both of them an their families since middle school, they got married senior year of college, they've only slept with each other (as far as I know), been married about 10 years. I don't live in the same state and never have since they've been married so I don't know their day-to-day but seems like they're pretty distant the last few years. They have had a lot of trouble getting pregnant and spent a lot of money for no baby. She was adopted and apparently had a really shitty life until about 8 or 9 when she hit the jackpot in terms of families (very wealthy family). She carries a lot of issues.

If she's done with sex, he's not, and the love is seemingly gone, is there any hope? I know the answer but want perspective. I know this happens all the time but it's hard to see with close friends. I'm planning to talk to him this evening and want to be helpful, instead of the usual dick jokes and booze/strip club/prostitute solutions.