Sex is whatever one makes of it, like most things. It may ennoble, it may demean. And like all the physical things it is an allegory of a deeper reality.
If we ennoble it here, like if we ennoble anything else here we will have it in the purest state when we leave the material world. The material world is reality flatenned out to three or four dimensions. Just like a picture is a relaity flatenned to two dimensions. Our life here is constricted because it is material. In the Other we will recognize things, but they will be beyond what we can conceive now. I think to start with one may feel absolutely lost till one gets a "foothold". But I don't know.
What the Qur'an says, I can't remember the aya, we will get what we desire. By that of course, I do not understand the 72 sex servicers or anything of the kind, but those desires, the deep desires of the heart for beauty, justice, rahma, joy, trust, compannionship, extasis..., whatever our heart desires. We don't get in this world all we crave for, but the mere belief in it makes for a satisfactory life. In sha Allah may we all attain to that and may God forgive us our little material meannesses.
Salaam