I would be so hurt. My man looking for pleasure from another woman? I would take that so hard.
The trust would be gone. You will always resent him and in the back of your mind wonder if he was with someone else.
I can't tell you what to do. He has dismantled your marriage single handily. Whatever you decide to do, this was not your fault. Its better to know this now then later down the road.