"But I cannot believe something is 'right' just because the government, or even the majority of the rest of the population, say I should."
Perhaps not. But that's how democracy works and I think democratic mistakes, if such they be, are better than an authoritarian figure making the rules. If we discover that our current 'lenience' about homosexuality is wrong and cause harm to people, then we can change things in future. Democracies are, in general, improving things for people and they are generally much more tolerant of 'divergence' than religious leaders have traditionally been. It's about the best way forward for a civilised society and what suits most people.