I'm glad you've got support today OP.
I know it can be really overwhelming when everyone is giving different advice and your head is spinning, especially as it's your world that has come crashing down around you.
Only you can know if this is something you can get beyond and whether or not you believe him.
Personally, the way he reacted when he came back would have been the nail in the coffin for me. At no point has he shown remorse, apologised, begged for forgiveness or even admitted he is in the wrong.
He's clearly gone off, orchestrated this plan in his head for talking his way out of it. He hasn't cared one smidgen about your feelings and that tells me that he's checked out of the relationship, regardless of this incident. All he cares about is saving face.
If it were me: I'd send him a message while he is at work (knowing he will be sweating on it all day and then not answering my phone to him) saying...
For someone who has been caught sending personal and flirtatious messages, emotionally cheating, (and for all I know, worse may have happened) you have a ridiculous amount of audacity to try and twist the situation to make me appear the 'bad guy'.
My intuition was proved correct. At no point have you apologised, been remorseful or even considered how I might be feeling.
It is very clear to me that you no longer love me or have respect for me. Therefore, our marriage is over.
However, you are not me and discussing things with your friend will help as she knows the ins and outs of your life, so could give advice based on better understanding of the situation and marriage.
Just please please don't let him get into your head and let you take any blame in this. He is the only one in the wrong here. He is gaslighting you. You deserve SO much more.❤️
Whatever you decide, I hope you are ok. You are strong and can get through this.