Elisabeth,
Pat is away at a special hip resurfacing conference in Baltimore, but let me give you my take from what I've read.
Many women, or should I say most all women return to a healthy lifestyle and their range of motion is sometimes better on their operated hip than on their good hip.
Many women even go back to serious yoga post-op say 6 months to a year.... you have to be careful about dislocations early on though.
So in answer to your question my bet is that you'll return to a happy sex life once you've recovered.
Make sure you find a surgeon who is very experienced, that is most IMPORTANT, I cannot stress that enough.
BTW-- I was operated on August 6th last year, this summer I've been to several amusment parks, went white water rafting and even water skied off of our boat on the rivers here in Pgh, pre-op I could not tie my shoes or put on my own socks, now I am fine and living a good life now.
Good luck,
Chuck