Help, totally stuck. Has anyone else been here?

[Isawthesignanditopenedupmyeyes]

I’ve been with my husband for 25 years and it’s always been a bit rocky, we aren’t necessarily well matched. He’s very laid back, not ambitious at all, manual worker. I’m the opposite, stressed, professional job, successful at work.
I have a simmering resetment at being the main bread earner and his inability to manage finances. He’s had a lot of debt from his inability to run a business (repeatedly) that I pay off.
I’m so angry about it that I’m so unfair to him in the rest of our lives. I snap at the littlest thing, scream at him in front of the children. He doesn’t/can’t change over the finance issue.
Is great in every other area, fabulous parent, great around the house, funny, kind.
I know I should accept we are good at different things and play to our strengths and help him with his business/get employment instead (which is where the debt arises from) but I’m so bloody angry and resentful.
I work harder and harder to make sure we are financially secure as I never know what the next financial surprise may be and don’t want to rely on him financially at all (and I don’t).
I can’t afford to divorce him. I don’t even know if I want to.
We don’t have sex. He wants to, I have no desire to have sex with him and have had to stop myself from being attracted to other men.
I’m a horrible person with him and he doesn’t deserve this.
Feel totally and utterly stuck. Have posted quite a few times over the years and I’m still in the same position. Can anyone offer any words of wisdom to help be move forward?

Do what you can to get those debts back in his name on his own loans or his own credit cards.

I doubt he's going to fall for that given the last few days. I think op may have to suck it up. Possible that they will be considered jointly liable if both parties benefitted, tho.