Yes, there are sexually compatible couples. I consider my H and I sexually compatible in spite of a difference in desire level. We're compatible in the importance we place on it within our marriage. We're compatible in the meaning we place on sex. It is this compatibility which keeps the differences in our desire level and the ups and downs that have occurred in our sex life from having a detrimental effect on our marriage. I don't even think this type of compatibility is essential as long as you're aware of where the differences are, accept the differences, and figure out a way to handle them which works for the two of you.
I would not doubt that there is positive correlation between high desire for sex and the high level of importance and meaning of sex. They aren't exactly the same thing, however. You need to find out how important sex is to him with respect to its role and meaning within marriage, its meaning to him as an expression of love, and what his expectations are of you in terms of meeting his sexual needs. It will be these things, more than his physical attributes, that you will need to accept as being an essential part of who he is. The likelihood of your changing his mind about these things is pretty slim. Ideally, he will accept your view of these things as being an essential part of you and just as valid. The likelihood of his changing your mind is equally slim.
You then keep the communication lines open regarding sexual needs. This will be particularly important if the two of you don't share the same view of the meaning of sex. You will need to plan on and accept that you will be having sex more often than you need and at times when you're not really into it. And ideally, he will need to plan on and accept getting turned down probably more often than he would like. Of course, you only have control over yourself and your own response.
Consider having a conversation about the meaning of sex, regardless of issues of desire, frequency, and quality. Don't let it turn into a debate as to the "right" way to think about sex. You're finding out more about each other not trying to change each other.