It's a lie. They lose interest in sex with said dude. Women get freakier as they get older and cool off around menopause. Probably still like fukking.
The reason behind why married women no longer choose to have sex with their husband is irrelevant. The point is that as the husband, you've basically relegated complete control of your sex life to the whims of your wife and there's nothing you can really do about it.