It's a very popular joke. I have no idea how many people take it seriously, since those would probably not say they do.

I imagine most people that buy a candle like that do it for somebody else's birthday to imply the other person is gay.