I agree you need to show him the harsh realities.
I kicked mine out at 6am, 7 hours after I discovered the truth (which wasn't even the actual full truth but it was enough for me). He left with a bag and a sobbing goodbye to the kids (always was a drama queen). I changed the locks and immediately told all our friends and our mutual boss what he'd been up to. (I was the more senior and I think he had supposed I'd shrivel up in shame and not want to tell anyone: not fucking likely). He lost his job for shagging a junior at work (who turned out to be just one OW he'd been messing with) and was living in a hotel.
After a week he killed himself, which is not a desirable outcome by any means, but he was very feeble minded (which existed uneasily alongside a blistering arrogance) and loved victim status, literally, more than life itself. Most men wouldn't do that but my point is that he had never dreamed there could be any real consequences I don't think. I honestly think he felt that it would all just work out in his favour. And then, the shock that he'd made a fool of himself and lost everything. He'd spent a year messing me and the kids about: wasn't sure what he wanted, didn't want to go, didn't want to try and make it work though, either. Belittled me and mocked me at every turn. So he stayed and made life hell with constant picking and bitching and slagging off his kids (yes his kids) to all the young women he was hanging out with. Oh and used a bereavement of EIGHTEEN years previously (his mum) as an excuse to treat me like shit. It was only when he was booted out unexpectedly, and suddenly was exposed as an adulterous creep with no time to construct a favourable story, that he came round fast and begged to come home. It was too late for me and I refused. It's a shame he took such a cowardly way out and succeeded in hurting us even more, rather than facing up to the consequences of thinking with your willie. But bloody hell, he certainly saw the consequences when they came.
This is always what cheaters need to see and feel, fast. They tend to then very suddenly work out 'what they want'. Often it's their wife and family although even then their 'loss' is mixed up with the loss of a family home, kids, 'nice guy' reputation, double salary. So it's hard to know how genuine their remorse is anyway. But kicking them out beats letting them do what they want. They sure as hell never chose their wife when she does the pick me dance.