I got the impression Spawn-Astarion's enjoyment of sex is related to how he feels about his partner. When he is your friend he has a line about how his conquests failed to give him even temporary bliss often (something along those lines) and the drow scene doesn't go well with him either. Otoh hand he mentions that he overall enjoyed his time with the PC even though complicated feelings about his past soured that enjoyment. It's never clearly stated where he draws the line of "not wanting to be thought of in terms of sex" or how he eventually resolves it, but party banter suggests that once Caz is dead, he's at least heavily into pda again, to the point of annoying Lae'zel with it.
If he's your player character it's up for your interpretation how he deals with it, and thinking it through and coming to satisfying solutions for yourself is part of the fun. He can also always stay single and become a Harper.
