No, he actually didn't. He developed the Archie character as one to be hated and reviled as a bigot. He was clueless and had no idea people would LOVE Archie and embrace his "America, Love it or Leave it" attitude.
You are so right!
Lear did want Archie to be somewhat relatable. Writers in TV know that “Love to Hate” characters can’t be TOO hateful. Otherwise people won’t want to spend time with them.