It's used as a perjorative slur. Generally it implies that someone is pretending to be gay but is in fact straight and as a person is only good for adding to the population, implying in the process low intelligence, low worth, etc.