I grew up believing that loving a woman (sex) was for procreation only. To have children and raise a family. I'm now 67 years old. I am a grandfather several times over and my wife is no longer with me,
Is it a sin to want the affection (sex) of a woman knowing it is not for the procreation of children?
Are you talking about sexual intercourse outside of marriage? If so, what is 'fornication' according to the Bible?
Take a read of 1 Corinthians 6:18-20 (NLT):
18 Run from sexual sin [fornication]! No other sin so clearly affects the body as this one does. For sexual immorality is a sin against your own body. 19 Don’t you realize that your body is the temple of the Holy Spirit, who lives in you and was given to you by God? You do not belong to yourself, 20 for God bought you with a high price. So you must honor God with your body.
First Corinthians 7:1-2 (NLT) states:
Now regarding the questions you asked in your letter. Yes, it is good to abstain from sexual relations. 2 But because there is so much sexual immorality [fornication], each man should have his own wife, and each woman should have her own husband.
What about this condemnation of sexual immorality in 1 Cor 6:9-11 (NLT)?
9 Don’t you realize that those who do wrong will not inherit the Kingdom of God? Don’t fool yourselves. Those who indulge in sexual sin, or who worship idols, or commit adultery, or are male prostitutes, or practice homosexuality, 10 or are thieves, or greedy people, or drunkards, or are abusive, or cheat people—none of these will inherit the Kingdom of God. 11 Some of you were once like that. But you were cleansed; you were made holy; you were made right with God by calling on the name of the Lord Jesus Christ and by the Spirit of our God (emphasis added).
Sexual intercourse practised constantly outside of marriage, whether in action or in the mind (Matt 5:28), will prevent a person from entering God's kingdom.
Yours is a serious question with eternal consequences - eternal damnation - if it is practised outside of marriage.
As for sex for procreation only within marriage and not for pleasure, I'd like to see that defended from the NT. I don't know of any verses that teach that. Please direct me to such if they are there.
Oz