@CBC123I think what you need to look at is the foundations of your relationship. Is he a good person? Is he kind, loving, supportive or is he a bit of a shit anyway?
If the foundation is rocky and there are much wider issues then don’t give all your energy to saving something that is broken.
Also, don’t stay for your kids. It’s not right for your children to live in an environment that’s unhealthy and unhappy. That’s more harmful than two separated parents.
FWIW here’s my experience.
My relationship survived and thrived.
I had what was mostly an emotional affair although there were some physical boundaries crossed.
I was confused, bored, seeking attention and excitement and fell for a colleague. I was having a bit of a crisis I think.
It went on for over a year and I didn’t feel guilty at all at the time. I had convinced myself it was ok because I wasn’t getting what I needed in my relationship.
of course that was bullshit but it’s what I needed to believe.
i genuinely loved my partner throughout but i was unhappy and looking for external reasons and solutions.
The guy pulled back and I was broken and fell apart a bit.
I eventually told my partner who was of course devastated but I think suspected. We worked through it, talked a lot, no excuses made and no blame.
I am thankful every single day that he was able to forgive me and rebuild. The relationship we have now I feel was possible because of that huge rupture as it scared the shit out of us both.
I’m not recommending this as an approach but sharing my experience.