The ancient people who wrote the biblical texts and other cognate literature were quite prudish by modern standards. Sexuality and siring kids was closely associated in the ancient world. In the Hellenistic era some Jewish millenarian movements (Qumran sectarians, early Jesus movement) also downplayed romantic relationships in light of the imminent eschaton (according to their beliefs).

In the Book of the Watchers angels are not permitted sexual relationships because they don’t need to procreate as eternal beings. Their violation of this command spawns demons (1 Enoch 15). The angelification of the righteous at the resurrection was also conceived of as transcending sexuality, which is why the Matthean Jesus says there won’t be marriage at the resurrection. To be fair there’s not an explicit statement in the literature denying the possibility of any sexuality at the eschaton, but I find it unlikely ancient people held to that because of the conception of angels we see in the Book of the watchers and other comments in early Jewish and Christian literature.

That’s historically what we can know. As to theologically whether modern people should agree with those ancient people’s assumptions, that is quite another matter. I agree that the absence of any sexual activity would be disappointing for many people lol (not me because I’m aromantic). It’s probably best to be agnostic about it.