In the end, it only matters what you want to do.
How badly are you hurt by his behavior?
Do you feel that his apology and plea for forgiveness is genuine?
Does is seem to you that he was in an emotional affair (EA) with the woman? Do you think he is likely to repeat the same thing, if he thought he could get away with it?
What’s your level of commitment? What are your own beliefs about marriage and divorce?
Search your heart. Get good advice from people who have recovered from similar infidelity. (The case with my wife isn’t similar, since she’s in a full-blown affair which is ongoing, so I don’t feel like I can offer advice, just questions to help you think things through.)
If my wife did that, I would insist on marriage counseling, so that the counselor can meditate conversation and help us talk about the issues. (Mainly because I feel like I would need someone who can help me express my thoughts and feelings in a way that my wife will understand. I’m not the best verbal communicators, and I get tongue-tied when it comes to intense emotions.)
My story in a nutshell, for some perspective: (My wife is in a full emotional and physical affair, and I’m fighting to keep the marriage together. I made my decision a long, long time ago that I am committed to her for life, and I’m willing to wait as long as it takes for her to turn back towards me… if ever. If we do remain married, I will insist on marriage counseling with a professional and with our pastor, not just meeting with our pastor. I also think she needs therapy to deal with childhood issues, which I think contributed to her decision to wander.)