This all seems so interesting to me. I know two people in my life right now who have had pretty much opposite responses, both are women. Woman 1 was in a happy, LTR, married, and had just had a baby. She found out that her husband (been with for 8 years) had been on dating apps for years, though he claims to have never physically cheated, and there is no proof of that, though she's unsure. She still pretty much immediately decided on divorce.
Woman 2 is in a miserable marriage, has been unhappy, if not miserable, for years, has explicitly said she neither loves nor respects her husband, doesn't even like him. She cheated on him with someone for months before he found out, yet they're still together several months later, and it doesn't appear they will divorce even though things are now worse than ever (the affair just caused more turmoil; no constructive discussion or changes). They'll just continue being miserable. They have three kids, oldest is 15.
So interesting to me the different reactions people have to these sorts of things.