I've been through this. It's utterly body crushing and soul destroying. It's not sad that someone else found you attractive, or that you enjoyed some physical attention and affection. Not at all!
Every day you don't have sex, every week or month, that's you compromising to him. Obviously he can't compromise the other way around as you want him to want you physically, not be forced into it.
So, you need to stop compromising in another way, because it's hard to explain to others how exhausting this part is, but it really is.
You need to get some control here. If he's not masturbating, or has a porn addiction, then he's asexual, temporarily or not. If that's not how he's always been then he has three choices, which you need to put to him. 1. GP to check for physical issues.
- A marriage counselor, or a sex therapist.
- Do nothing.
All three are valid options. Give him a date by which his decision needs to be made and action taken.
All three have consequences. The first two you will support him in. The third one, totally valid for him, but unacceptable for you as a way of life as you don't want to be in a sexless, unaffectionate marriage any more than you want to be married to a gay man.
Expect it to be 3 and plan for that.
Be serious.
He has every right to no sex.
You have every right to sex.
The two are not compatible in a monogamous relationship (and he clearly wouldn't cope in an open one).
I'm glad you're married though, you're in a stronger position now if you do end the relationship.
It's also worth pointing out that it's better to be single and not able to find a date than it is to be in a committed relationship that is sexless. Utterly different due to choice. Which brings me back to you. There IS choice here for you. If you accept him like this by staying with him for the sake of the kids, that's your choice. You're free to make it. You can't then complain or be upset with him when he doesn't change.
For the first two options, I would also have a finite time in mind. Say a year for marriage Counselling, if things then haven't changed the options are dr or end.
If the dr says no physical problems, you're back to options 2 & 3.
You're going to have to drive this forward, but don't do things for him, he has a responsibility here. He makes dr appointment for example, you can accompany him if he wants, but he has to do it, otherwise you're increasing your responsibility, which he's already trying to increase. If it's not his problem, that means nothing will change, because he's not accepting it.
If you're a sexual person, sex is a bedrock of life. It is no minor issue to have it removed.