It can also make your cllmaxs very intense, but when you're high sex often just seems like too much work. Once you sober up your sex drive returns and your cllmaxs aren't as good.
I only smoke a couple of times a week, so I haven't had any experience with a seriously lowered sex drive, but when I am high I often want to just lie around, and marijuana can make you seriously tired and sleepy.