For a standard monogamous relationship to work, you have to be both mentally and physically attracted to your partner.
I know that a lot of people think that personality > looks, but honestly physical attraction is just as important. I mean, you don't want to be having deep meaningful conversations with your partner, look them in the face and think "damn, I really don't find you attractive".
If you don't think you'll ever find him physically attractive, and physical relations is something you value, then I'd suggest you end it and maybe explain that he's just not your type physically.