Sorry to hear that.
But, I don't see why that's having your cake and eating it too? A relationship should be fulfilling to you in all aspects. A companion to talk to about anything, a person you feel safe being with (no abuse,) and someone to keep you physically happy as well. Intimacy is emotional, spiritual, and physical. Maybe it's impossible to meet all at 100%, but we should all strive to be as close as possible. And, if one 3rd of the pie will never even come close? That's a huge problem in a relationship, especially if you end up straying.
I don't see why the other person is unwilling to work on that?