I'm so sorry - that's really rotten for you. It sounds as though all you can do is detach and let him get on with things. You are calling this the end, but only you can decide that.
But it sounds as though he has made his decision at least for now - although you could bear in mind the stats - only 3-5% of affairs end up as marriages and around 75% of those fail. But, that's a lot of waiting, and this may not be much help to you right now.
One thing I keep telling myself is that my happiness does not depend solely on my S. There are many other good things in my life - and I need to focus on the other good things right now. Only time will tell who is happier in the longer term.
He will have to live with the fact that he destroyed your relationship - and he may not end up all that happy in this relationship going forwards. You on the other hand know that you did all that you were possibly able to do to try and save things. I know which person I would rather be out of those two options.
That said, probably none of this offers much comfort at this point - but I do send my very best wishes to you....
Toots x
T 13 M 7 Me 48 H 46 SS 15 BD 7.14 PA D final 5.16 (H filed)
We receive & we lose, and must try to achieve gratitude & embrace with whole hearts whatever of life that remains after the losses - Dubus