A conversation with a stranger gave me the whole truth😅

So from the very beginning and this is a long one😅 so we already have a 1 year old daughter together, we’ve been in a bit of a rut for a good while and in April of this year I discover my other half of 6 years had been messaging another female or so I thought. I told him as long as it was just looking for somebody to talk to I could deal with that. Forward to 48 hours ago he’s disappears out after work and i discover he’s out with boys all night drinking highly pissed of by this point as I was working at 7am that morning and needed him home for childcare, anyway he comes back here falls asleep and I discovered the girl he’d be messaging he now had been talking to on TikTok, I relieved a shite ton of screen shots of chats between them and decide to contact the girl myself as I could tell he was still hiding something me and her finally get past her thinking she something amazing to him and we get down to the dirty deeds she tells me they’ve slept together and they spoke all the time he told her right personal shite, visited at her home, meet her friends and family and so fourth.

Forward to last night, he tells me exactly what I needed to know tells me he knows he fucked up and that’s why he’s been drinking a lot lately because he felt terrible and with finding out I’m pregnant through all this he’s disgusted with himself. He knows he’ll never be trusted at least not at the moment, it’s never been something we’ve had a problem with before. During this time we were in a complete rut I myself thought of leaving and cheating more than once but just not the heart to follow through with either as I love him.

I’m in two minds what to do, I’d like think we could find a way to move on and actually work on some form of relationship known that it’ll never be what it was before but then I think people who go through this sort of thing their relationship usually never change and I’ve just never seen a positive relationship after something like it..

He says he did find her attractive but for him it was nothing more than because she was somebody who was interested in him and gave him attention. She was actually really lovely snd I felt crap that she’d been caught in this bloody mess and was made sound like a crazy woman as I was made out to her. And to put the boot in even more in pregnant with baby number two.

Has anyone any advice on moving forward if at all possible?

Anyone have a successful story after something like this?

Edit ::: turns out he didn’t use a condom, resulting in her taking the morning after pill, he heavily lead this lady on in response to how he to spoke to her, meet and was brilliant with her little one all while doing the very bare minimum at home with our little girl. Meet her friends, mum sister.. told her it was the best night he’d had in years. Now along side finally getting most of the truth out of him, obviously I’ll be getting tested I mean how disgusting I’m pregnant. He’s continued to sleep with known he done those deeds and I still had no knowledge his response ‘I didn’t want to lose everything, I genuinely thought our relationship was over you wouldn’t come near me. I’m and genuinely sorry and have done nothing but regret it.’

I’d love to believe it but I am more a fool if I don’t just end it now? I obviously need my space from him at the moment to just process all the details I’ve gotten over the last little while but is there any actual success stories from something like this or does that space just become permanent?