I agree with everything everyone has said here, even if, as you, say, you are happy in the "friend zone", he's not being a friend to you to treat you like that, he's not being kind and he's not valuing you the way you need to be valued by someone who is claiming friendship.
Plus, if one person wants more than the other, well, you need to be brutally honest with yourself, isn't what you want, a relationship? He said that's not what he wants, so isn't it about time to free yourself up to find someone who does want to be with you, in that way?
You, my dear, are not dumb, but you are not facing reality, because the reality hurts, but it's like when a band aid needs to come off, you just have to rip it off, it will hurt for a little while, but in the long term, you can heal better and you will find life richer and freer and having more promise for that short term pain.
Short term pain for long term gain.
My Aspie bf didn't want a relationship, at first, and I had to give him space, I had to break up with him, he wasn't ready. He genuinely wanted the friendship though, and we got there in the end. I had to back off. I couldn't be clingy because that made him feel trapped. I was a good friend, but I had to be a better friend to myself and not allow myself to be devalued by the situation. I'm still a good friend, and although our relationship isn't "conventional", we are besties and he treats me very well, most of the time.
On the occasions he shouts at me, I have to stick up for myself, give him space, stand my ground, and he always apologises and is very sorry and loving afterwards. He never calls me names though, is never disrespectful like that. I couldn't allow myself to tolerate that.