Most people accept that words used in the past to demean certain groups and set them apart - like "nigger" "darkie" "chink", etc., are offensive and have no place in a decent society.
The words "queer" "poof" "fairy", etc., originate from a time when homosexuality was criminalised and there was a great deal of hatred and mistrust directed at gay people. These terms were meant to demean and keep gay people firmly set apart from heterosexual society. They were not used affectionately but sneeringly - and their use today perpetuates a notion of a sort of wierd and hilarious "otherness", even if it is presented as just a cheery little joke.