It must be horrible for you right now.
And you are still in shock.
Sugary tea as suggested will keep you going for a while.
Try to eat. Little and often.
If, as he says, it's just like going to the pub. Would he really be in the pub every single night. Talking to people all through the night and ignoring and neglecting his family?
I know if my OH was in the pub every night until all hours that I'd be kicking his arse out of the house.
He still can't see or admit that this is wrong. He claims women are falling in love with him. Can you imagine if it was the other way around? How would he react?
Thing is, so far, there have never been any consequences for what he is doing. You say please don't, he carries on, you get upset, but nothing changes for him.
I think you need some space to think seriously about how you want your life to pan out.
Do you want to be on the look-out all the time at what he is up to?
Worrying things will maybe go too far with one of them.
Or that he moves things closer to home and starts to meet up with people.
That is no doubt, how it will progress.
Will he agree to counselling? I think he needs some on his own to understand why on earth he feels the need to completely neglect his family over total strangers. Very odd behaviour.
For today, please try to get some real life help and support.
No-one who loves you would want you to feel like you do without having the opportunity to be there for you.