So to sum up - OP doesn't like her husband, doesn't fancy him, is happy not to share a bed with him, says he doesn't give her enough support and he called her ugly during a fight.
She is happy to refuse to have sex with him ostensibly forever. He wants sex.
Regardless of the reasons you cannot expect someone to stick around paying the bills while a vital chunk of your married life is sealed off to them. Yes, sex is vital in a marriage to me, I'd be devastated if my husband didn't want to have sex with me. Yes, sex is vital in the marriage to her husband.
There have been times we could not have sex over the years because of medical issues (on both sides). So what we did was discuss that and figure out when it would be safe/comfortable again and look forward to that day.
Neither of us reacted with disgust of the other and relief we could say no to sex. That's an unhealthy way to feel about a spouse and shows the marriage has completely broken down.
The disingenousness of those shouting NO SEX FOR HIM FOREVER AND HE CAN JUST PUT UP WITH IT! is clear. They are pretending this is a hiatus, that OP gets that he actually does have a right to want sex and that she acknowledges his right to want sex.
You will note I DID NOT SAY he has a right to force her to have sex or a right to have sex with her so don't lie about that. I am quite clear on bodily autonomy.
But he DOES HAVE a right to want sex wtihin a functioning marriage.
OP is determined (yes, she is, don't be disingenous) not to have sex with him and there is nothing to indicate she wants to discuss that or head towards a healthy, functional sexual relationship where they are both happy.
"I would've left a long time ago really but not sure how I would do it on my own. I think I am just not attracted to him really, ive tried to make it work but I just can't force that anymore."
She wants him to stay to keep paying the bills and maintain the family unit. Sexless. He's not going to agree to that.
Again, the reasons for this situation are not under discussion, not even the reality that he has multiple sclerosis. None of that matters.
What matters is that OP think the solution is "no sex" and her husband disagrees completely.
She's allowed not to want sex with him for any reason or none. He's allowed not to agree with no sex.
So to sum up - OP doesn't like her husband, doesn't fancy him, is happy not to share a bed with him and doesn't want sex with him.
So the marriage is over and it's time for OP to get a job and move on.
It's actually not complicated, not at all.