Even after they have repented how does that effect their future relationships and behaviours. Speaking from experience on this topic is greatly appreciated
My experience is that sexual sin can stay for decades; but, as I grow in loving, it goes away more and more.
It seems my character makes me more or less available to sinning, in general. And, I would say, God has changed me deeply so I am less available now to sinning, than I was.
And, practically, what helps is not to feed myself with wrong stuff of what I am thinking, imagining, and looking at . . . where I agree to give my attention.
Trust God to guide my attention . . . yes, all the time to submit to how God rules us in His peace (Colossians 3:15, Philippians 4:6-7), as well as God gives us the character submissive so we do this.
And with this I am busy with loving, instead of pleasure seeking and arguing and complaining and trying to control people > 1 Peter 5:3.
And my experience with God's word is >
Jesus received that woman at the well and the adulteress of John chapter eight. He used the woman at the well to preach, and told the adulteress to sin no more; so He knows it is realistic to expect us to sin no more. Because this is possible with God and how He is able to correct our character > Hebrews 12:4-14. So, I hold myself to this and consider myself accountable for this.
So, I do not excuse my failure or anyone else's, but pray for what is possible with God. All judgment is committed to Jesus > John 5:22-23. So, even now in prayer I offer things to Jesus, for Him to judge how He pleases to create His results with each situation, including my failures to stay out of lust things of the eyes and the body > 1 John 2:16.
And Jesus can determine what He does with each woman, and have me love each one the way He wants.
I see there are victim sins, and victimizer sins - - prey and predator > like in the animal kingdom, there are prey animals and predators, and we see how the prey can even help the predators.
The prey can develop cover which the predators can also use for getting near to their prey. And then the prey can have a way of not standing up to the predators.
Both prey and predator sinning can involve seeking pleasure. And sexual sensations can be very intense, and any nicer or nastier person can make sexual pleasure a major treasure and idol because of how it is intense and can be free and not require any character and education and social status to get it.
People can build their identity around how they prefer to get sexual pleasure. But in our weakness for pleasure we are also weak for the pain and shame we can suffer while a selfish spirit works and drives us to seek a pleasure. There is the spirit of Satan who "works" people to do sins > Ephesians 2:2. And this spiritual being is nasty so it is desperate for pleasure to feel something nicer than its boredom, loneliness, frustration, arguing, complaining, anger, and unforgiveness.
I see a connection, how God's word says Satan's spirit "works", and those lusts and drives can work so hard. And nasty ways of reacting to not getting pleasure and control also can work so hard.
But the Bible says to put away and put to death these things; and love, instead, in sharing with God > Colossians 3:1-16.
And my devotional experience is that Jesus is the best of all in existence, along with our Father and the Holy Spirit. And Jesus so superior is not at all conceited about His superiority. And so Jesus is ready for any person of any past to be adopted as part of His Bride. He is not afraid to marry any woman, but He does expect us to prepare for Him by being corrected, how God is able, and discover how He has us loving as family while loving any and all people of Satan's kingdom, how He rules us to love each one in the creativity of His peace > Colossians 3:15.
So Jesus our example has experience with how to be humble to love any and all people. But humans can make sexual stuff an idol and take great pride in getting it. And because of this worldly worry about sex, ones can fear being betrayed sexually and I can get concerned about if I can perform the way a woman dictates if I marry her. But if we are humble with Jesus, I see He will have our attention elsewhere.