Honestly in my social circles, people who oppose gay marriage might as well be LaRouchites. They're just so fringe and unheard of you can simply assume anyone you meet isn't one. They basically don't exist in your general assumption. So I can't make any real generalizations about them.
I know people who don't care about gay marriage but don't know anyone who is opposed to it. Whether it is rednecks who throw the word "fag" around, members of experimental bands or grad school students, the idea of opposing gay marriage on principle is viewed on a spectrum from being an obnoxious position held by fundamentalists to being akin to neo-nazism.
This is not to say that opposition to gay marriage is a mark of unintelligence but rather that it is an unintelligible position in most of the country at this point.
My experiences with people I know are similar, but it is important to remember that the people we know are not reflective of the entire country. People cluster into like minded groups. Big Religion is still an enormously powerful institution even if you do not personally know anybody under its control.