That actually was a popular way of life for philosophers in late antiquity where they would abstain from sex for pleasure, but would still do it for conception. I can't recall the name, but there was one dude who, when he figured out that he can't have children, told his wife that she can leave him for someone else if she wants because he will not engage in sexual behaviour anymore.
This was from Edward J. Watts' book on Hypatia.
"It is not that we have a short time to live, but that we waste a lot of it"
And at the end:
"No one keeps death in view, no one refrains from far-reaching hopes; some men, indeed, even arrange for things that lie beyond life—huge masses of tombs and dedications of public works and gifts for their funeral-pyres and ostentatious funerals. But, in very truth, the funerals of such men ought to be conducted by the light of torches and wax tapers, as though they had lived but the tiniest span." [As if a child had died]
Seneca, On the Shortness of Life