Citing his faith, President Obama announces his support of same-sex marriage, and conservatives see political opportunity