I hear many of stories from men saying they did it because wife/girlfriend gained weight etc.
A remotely decent man who was truly so turned off by his partner's weight would either speak to her and encourage her to lose it, and if she didn't within a reasonable timeframe, would separate. He wouldn't cheat on her with prostitutes and non prostitutes.
On the general subject, you seen to think him cheating on you with non prostitutes and prostitute ms is a reflection in you. But he would cheat on anybody with prostitutes and non prostitutes. He wants sex with multiple different women - no woman would be immune from being cheated on by him.
That's what men want when they cheat repeatedly without leaving.
He's clearly an addictive thrill/high seeker and the cheating is another aspect of it. As well as his lack of basic morals and integrity... And empathy for other people.
He is a mal adjusted, disordered person. A drug addict, a repeated cheater, a liar .... That is his character, what had that got to do with you? He'd be the same with anybody. It's who he is.
It sounds like the kids "adore" him because you've hidden and made up for all his selfishness and disorder and disinterest and chaos. It sounds like you've done everything for and with them, while he's not been a real parent. He still gets adored however because kids naturally love and hero worship their parents. It sounds like your whole household panders to him too. They've grown up in an incredibly unhealthy, fake, unbalanced dynamic - while you did your utmost to compensate for his lack of responsible, unselfish, caring, active, normal parenting.
The drug use is a deal breaker .... The deal should have been broken long ago.
The cheating is a deal breaker.
The prostitute use is a deal breaker.
How much of your family money has he spent on drugs and now sex workers.
He owes you and kids probably 100k.
Whether he keeps a business running or not, he's a fucking disaster area, loser and degenerate.
Stop helping him pretend he's normal.
Stop letting him treat you like something he wipes his feet on.
Where would you be if you'd been using drugs or cheating on him; out the door.
Bringing sex workers to your home. Never letting you get a break from the kids, impeding you getting work/a career, spending your family money on drugs, and sex with other women. Cheating on you repeatedly. People have killed their partners over less. And would probably have gotten considerable sympathy for doing so.
Fuck me; I dont know what to say to you ... Can you get counselling? Individual counselling.