Many Christians are worried about what today portends for religious freedom. I've written about it at length here. For most of us, day to day life will continue as usual. We'll deal with the public square as necessary, but we should never accept today's ruling as legitimate. The positive law rests upon the natural law and any positive law that purports to contradict the natural law is illegitimate and unjust.
"The American people" doesn't carry the same connotations as, say, the German people or the Chinese people. The Narrative holds that America is a nation of immigrants and that talk of core Americans is raciss and exclusionary. We are united by the ideals of the Declaration of Independence and the Constitution. For that reason, many right-liberal Americans recoil in horror if we criticize either document. For now they can take refuge in the Supreme Court's invention from wholecloth of a right to sodomite marriage (and they did manufacture it, don't misunderstand me.) But suppose we eventually passed Constitutional amendments explicitly guaranteeing positive rights to abortion and sodomy. If the Constitution explicitly violates the natural law, then right-liberals fear that the government would become illegitimate and we'd cease to be a nation at all. Balderdash. Caesar may try to violate the natural law, but we still have to obey the traffic laws.
Of course this will have serious implications for anyone considering government work that involves swearing to uphold the U.S. or state constitutions. I don't regret my own military service but if I had children I would strongly discourage them from going the same route. Bonald suggests that Christians need to become much more tribal. That post struck a cord with me. Godless heathens and Protestants seldom make me angry, but if I had any hair on my head I'd tear it out in rages over my fellow Catholics who side with the Church's enemies. Remember: Catholics support same-sex "marriage" at rates equal to or greater than the population as a whole.
As for me, my go-to response to inquiries on the subject is, "Yes, I oppose same-sex marriage. Go cry about it."