The pain prevention aspects of Lyrica (and its cousin Neurontin)
is a bit different than just pain medications, per se.
A pain medication, dulls or diminishes pain, even to the point of non-existence, by covering up the pain sensations.
They do not affect, neurologically.
Lyrica relieves pain by relieving neuro symptoms. If the pain is a jabbing symptom, it eliminates the jab, not the pain from the jab.
You don't minimally feel the jab, (but it doesn't bother you anymore) you don't get jabs, in the first place.
There are certain types of PN pain that are not symptomatic and that Lyrica won't affect. That is why a pain killer, is used-in conjunction with the Lyrica (an opiate or synthetic, like Tramadol), a 'cocktail' of meds, as it were. Together they work, usually better than either standing alone, to alleviate both the sx, and the pains.

As far as sex is concerned, if the Lyrica is doing what it is supposed to do, but s/e are evident- a supplement such as MrsD suggests, would be more in order- rather than the discontinuation of an effective med.