I’d go so far to say that unless those desires have been quashed a place in heaven would not be offered. You think our purified spirit will be having sex in heaven?
Now you’re recasting what I said in coarse terms in order to build your case against my point. If you don’t believe it, that’s fine. (And I don’t say that with bitterness.)
I will say though, that it is a general tendency in modern Christian thought to believe that all desire, and
especially sexual desire, are a barrier to entrance to Heaven. This isn’t so. What presents a barrier to entrance to Heaven, is
sin. Sexual desire is only sinful when it is
lustful. A
pure desire for union with the opposite sex, however, is not sinful in the least, but utterly sacred. Can the sacred, and a longing for it, keep a man (woman) from entering Heaven? Clearly not. Rather, his (her) ardent longing for it is a sign of his (her) eligibility.
As for scriptural support, within the Christian canon there is the Song of Solomon of course, and if we look beyond scripture to literature there is the tradition of courtly love. Outside the Christian canon the scriptural support for what I’m saying is overwhelming, but reference to any of that typically doesn’t gain much appreciation here.
P.S. Thinking more about your question of whether our “purified spirit will be having sex in heaven”, I think it actually deserves an answer and that answer is
yes. The thing to keep in mind though, is the adjective “purified”! I am also not saying that sex in Heaven should be imagined to be similar to the sexual act as experienced on earth – though I’m also not saying it shouldn’t. I believe it’s something that one shouldn’t attempt to describe.