Actually, it had been used in that sense since the '30s, by conforming gay men who prefered it to "fairy".
Since Graham Chapman was gay (the very normative kind who didn't like those who weren't normative, as proven by the frequent homophobia in the show) and knew these words fairly well, I'm fairly certain that "queer" in that sketch was pejorative for "homosexual".