I think your DH is having an affair.
The reason he is treating you so badly is because he is justifying it in his mind, to keep the guilt at bay.
So, you are the bad guy, you are difficult, it’s none of your business, he needs to think of himself and he’ll do what he likes. He’s dehumanised you, made you lesser, so he can treat you like this.
From what I’ve learned in my own, and other women’s marital dilemmas, is that pleading, reasoning and being upset doesn’t work. In fact it only feeds their ego. I’m not saying these feelings aren’t valid, just that I don’t think they work.
What you need to do right now, is save yourself, because you can’t save this marriage, only he can, and he might not.
You need to get as much info on his business, any savings and assets he has as you can. Search the house. Even if you can’t find anything, you can make a list of; he’s got a private pension, he works this many hours, this is his hourly rate. Work things out.
When does your rental end, or can you give notice?
Call round solicitors to get 30 mins free. Make an appointment with a good one.
When he gets back, just don’t speak to him. Move out to another room, or move his stuff out. Start making plans on your own. Don’t do anything for him when he gets back. Present him with an invoice for 1/2 all the bills. Keep a diary, go over old bills and see what you’ve paid versus what he pays, there may be financial abuse here. Let him do his own cleaning, washing, cooking etc .
You, join a gym, go out with your friends, get your hair done. Show him that when he is not around, you thrive. Show him that as a man, he is a weight round your neck, and once liberated you are like a free bird. Move all your money so he can’t get to it.
Don’t tell your DD anything else. She’ll come to regret siding with a selfish arsehole.
Let the OW have him. He’s a dud pup, a booby prize. He doesn’t contribute money to the household, he’s no spring chicken, you’ve had the best years of his life, let her wash his underpants and hear him fart and snore. Even your DD will hate him when she finds out he’s a cheater and a liar, as will your other DC.
A lot of women are really scared when their marriages break down, but then 6 months later wake up one morning feeling 10 stone lighter having offloaded and arsehole. They are poorer, but happier and liberated.