It’s devastating. I persevered for years although my husband denied ad naseum and only when the evidence was overwhelming (I caught him in the act) did he confess and only then to a fraction of what was really going on. It took another 18 months for me to leave, and now he is doing well at last, at least for now.
He’s got to want it for himself and knowing you are going to lose everything is sometimes not enough.