Question: what does it mean when he says he wants to be friends?
Answer: Basically, if he Wants to Actually be friends — then you have the personality concept locked in. Even if you two were very different types — being at least more than friends is applicable if you are still compatible to explicitly be friends. So in a nutshell, you lack the physical attraction for him.