I think a big part of it is that people are afraid that schools are going to start teaching about it, telling kids that it is perfectly normal and fine. We could start seeing cartoons with homosexuals in it. Why not? Cartoons show married heterosexual people, so if there's nothing wrong with practicing homosexuality then why not have gay couples in cartoons?
To me that's scary. But it's not near as scary as what was done to Christians in the Bible, so I guess we still have it pretty good here.
Probably. And so what? What do you think that will do? Human sexuality cannot be authored by cartoons or 'acceptance'. There was no day where you woke up and said "Gee, I've only been exposed to heterosexual media, guess I'll be straight!" I don't know if you have any people close to you who are gay; but if you do, talk to them sometime, honestly and openly, about what it was like for them to come out. Chances are, if they are anything like my friends, they wanted nothing more than to be straight. Begging and pleading to be straight, trying to be straight, getting into relationships with the opposite sex hoping it will "make" them straight. But it just doesn't work like that. The next step is acceptance of their own sexuality followed, often, by a rejection of that which opposes it. A defense mechanism of sorts; which is why so many leave the church and reject societal norms about relationships; because they aren't accepted as 'normal' in society.
I'm not sure why that's scary or why you think children would be harmed by it.
And yes, it is going to become less and less socially acceptable to oppose homosexuality. Just like it's not socially acceptable to oppose interracial marriage, equality for women, equality for persons of color, and other issues Christians have opposed through the years. I'm amazed by the ridiculously similar pattern race equality followed in the 60's, including in the church. The Methodist church HAS split over it's stance on slavery, and when a group of Methodist Pastors in the south came out in opposition of Jim Crow laws, they were ostracized and chastised.
If you believe it's right, then you believe it's right. Society shouldn't decide that for you. The world deciding that it's acceptable and deciding that it's not socially acceptable to oppose it is par for the course for Christians. Sometimes society helps us take off prejudices to help us understand the Bible better. Remember, Christians of previous decades believed very clearly that the Bible set white men above all other classes and that white women, followed by minorities, were set at a lower pedestal. And I'm not talking fringe groups; I'm talking the prevailing, majority Christian opinion. When interracial marriage was legalized churches were in an outrage that the nation was not being "biblically obedient" and were concerned that the "children" would be harmed. "I Love Lucy" was heavily criticized by many Christian groups as "promoting interracial marriage" (Lucy was white and her Husband was Puerto Rican), despite not really showing affection on screen and even sleeping in separate beds! (There's an entire season of I Love Lucy where Lucille Ball's stomach is hidden in every episode. She was pregnant. Though they were on the bleeding edge of society for showing an interracial couple; even they thought showing a pregnant woman on television was vulgar and inappropriate. And would only incite more vitrol as the 'character' would've had to be pregnant for it to make 'sense' and that meant an interracial Baby! Times DO change).
At the end of the day, though there are still Christians who believe the Bible still opposes interracial marriage and equality; no, society doesn't condone their behavior like it has tolerated it in the past. Nor will society, in the future, tolerate opposition to SSM. Society is moving with or without the church though. Society will continue to oppose and support things Christians, of various understandings, support and oppose.