Would someone be able to elaborate how a wife can say that she loves the Lord, but does not want to be married and wants a divorce? Especially in light of her husband (me) seeking the Lord and desiring to honor Him, doing his best to be what God wants him to be.
First, Anyone can say anything. There have been serial murderers that claimed to love G-d. That doesn't mean it's true.
Second, you need to understand that there is no connection between your two sentences.
A:
"Would someone be able to elaborate how a wife can say that she loves the Lord, but does not want to be married and wants a divorce?"
is not connected to
B:
"Especially in light of her husband (me) seeking the Lord and desiring to honor Him, doing his best to be what God wants him to be."
Those two things are not linked. In your mind you seem to be thinking that if you B is true, if a husband is seeking the lord and desiring to honor him, then the wife should not want a divorce.
Those two things are not linked or connected. The husband could be the most G-dly and wonderful husband in the world, and the wife could still want a divorce.
These are not related things. Do not think that your purity is going to cause someone else to do what you want.
If your 'godlyness' caused others to behave in good ways.... then explain to me how Judas betrayed Jesus Christ to death, just after Jesus literally washed the feet of Judas?
Jesus was more than just 'godly' he was G-d, and Judas sold him out to be killed.
And here's a sick truth of Human nature.
Human being typically respond and learn more from consequences than love. If you think that you are going to love your wife back to your side..... that may work, but typically it does not.
Just look at Israel. Under King Solomon, Israel was so wealthy and so blessed by G-d, they had peace on all sides, and were so prosperous and wealthy, that Silver had no value in the nation. They were so wealthy, that Silver was considered garbage.
And yet it wasn't even one full generation later, and the people of Israel were in idolatry and child sacrifice.
G-d was constantly dishing out or allowing consequences to harm Israel, and then they would return to him.
This idea that if you just love someone enough, they'll come around, usually doesn't work. This is why you have family interventions to confront someone who is addicted. Loving them endlessly doesn't turn them around. What turns them around is confrontation and heavy consequences.
And one last thing...
I mentioned the case of intervention for addiction, on purpose. You are thinking about this in a rational thoughtful way. She is not.
You need to understand that. When someone gets into a affair, it is almost like a drug. It's like being hooked on crack. She isn't thinking logically about this. She's hooked on a drug, and she wants her drug.
If you can think when you first got involved with your wife, and you had this thing going on where you are thinking about her all the time, and all you want to do is be with her, and when you are working you are thinking about what she's doing right then.....
If you had that, that's what she is likely going through. It will be hard for her to snap out of it.
If you want to travel this road, to reconcile your relationship, this is what you can expect to face and need to overcome. You will need a professional counselor to guide you through this. And to be honest, not all counselors are good at guiding people through this.
I'm not trying to put you off. But I'm also not going to white wash this, like it will be easy. It's not. She is going to be jonesing for that other guy, and likely for months.
And just to be honest, she may never come back to you, no matter what you do. That's just a fact. It's one of the reasons, I would never put up with it. I'd send her on her way, and be done with it.