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?
I don’t know you but my advice is that you talk to a therapist before you condemn yourself to a life of unhappiness. What you’re thinking about yourself is not always objective, even if you think it is. Being self-critical is not the same as being realistic