my wife was on the pill for a few years now... sex is the last thing on her mind.
She stopped taking it for a month now and I see a marked improvement. Not huge, but improvement. But now there's the chance of babies.
So for her, the pill works by making her not want any.