Thing is, sex is not a privilege. If you - as someone in such a situation as OP - can't accept that, you are in danger of growing.. hateful views.
No one is entitled to sex, I agree. But in a relationship, you are allowed to make clear what your needs are and move on if those needs aren't being met. It's not entitlement to know what you want. Having a 'dead bedroom' is why a lot of relationships end.
I don't want to become such a person, and it's clear that it's not their fault that they are not attracted to me. Realizing this helped me accept it.
If I may ask, was there any physical attraction between you two when you met?
There's actually too little cheese lady content on the timeline