Yes, sex is only a foreshadow of what intimacy and love is truly
like when we reach heaven. Matthew 22:30, Jesus said "At the
resurrection people will neither marry nor be given in marriage;
they will be like the angels in heaven."
Angels do not marry not because there is no sex in heaven but
because in heaven, the ecstacy of being in God's presence and
surrounded by His love will make even sexual orgasm on earth pale
in comparision.
Countless people who have had a near death experience (NDE)
reported that as they walk towards a bright light, they felt waves
upon waves of UNconditional love which was beyond words.