Well it’s even worse now you have told us you have only found out by accident and his sheer bad luck !! Of course he’s sorry, very sorry he’s been caught I don’t want to add to your pain but that really is unforgivable he is not your best friend, best friends aren’t deceitful, conniving, and selfish best friends care about your feelings
I m another who does not pay into the ‘men need sex’, ‘sex with a prostitute means nothing’ blah blah blah yes it blooming does it means he is enjoying himself in the most intimate of moments with someone else, probably even multiple ‘someone elses’, Gosh three years (that he has admitted to) he must have paid out a fortune as you mention he was visiting them regularly
I hope you can get over this but he’s not the man you thought you had married he’s not the best friend and soul mate you believed was by your side and that must feel like the end of the world A huge tragedy for you, you must be devastated Do you have a best friend (I know you have moved) that you can confide in even if over the phone
Please get some help don’t face this all alone you need support