I don't know that I agree that people wouldn't want to have sex, after all, you're treated to a massive surge in dopamine. You experience similar processes with something as simple as sugar, that causes a massive crash but people still eat sugar. Anything that involves activating the body's dopamine reward cycle has the potential to cause depression.
This isn't the article I originally read, but it's similar:
Your Brain On Sex | Reuniting
Exerpt:
"...you have many dopamine-raising possibilities—from Internet porn, gambling and alcohol, to the dopamine agonists drug companies are producing to light a fire under slumbering libidos (not recommended, due to risky side effects). These "fixes" make you feel better briefly, but as far as your well-being goes, they are like eating junk food—a net loss. As biologist Robert Sapolsky observed, there is a price for blasting our reward circuitry too enthusiastically in our efforts to counter the blues.
Unnaturally strong explosions of synthetic experience and sensation and pleasure evoke unnaturally strong degrees of habituation.... Our tragedy is that we just become hungrier." In short, there are advantages to steering for equilibrium initially, rather than always reaching for more stimulation to cope.
Your limbic system is not equipped to understand that there can be too much of a good thing. It just keeps rewarding you to do the same unrewarding things because they register as things that once served your ancestors. A "fix" just positions you for a continuous addictive cycle of highs, more lows, and a search for more highs. Many of us spend much of our sex lives caught in this cycle—with no obvious way out."
Agreed!