I'm attracted to his personality but not his body
Why are you attracted to him?
Because he's a nice person who makes me happy.
It's okay not to like everything about your partner. Just because things aren't perfect doesn't mean you should end the relationship because of this issue.
I want to get married with him but all he wants is sex.
You both should sit and have a conversation about your issues.  If he's a nice person as your said, I'm sure he'll understand it.