A few lost members, a few bitter comments, and some stares in the church...for the next few decades.
I got to see that a while back at a deacon ordination at a church I visited. Three of them were divorcees, and ones wife had died. A "concerned" woman with a little too much scorn in her voice spoke against them, quoting scripture that they should "have only one wife", which had been used as an excuse in the past to preclude divorcees from church service. The pastor (thankfully) shot her down by pointing out the obvious, it precluded polygamy, not the remarried or unmarried. This is a policy change that wasn't recent, but has taken decades for people to get their heads around. We're working on the same with women in ministry. My church was kicked out of the SBC for taking a firm stance, not taking the backward steps of the Fundamentalists. I'm happy to say we have several female deacons and associate pastors. I don't know that the older members have their pacemakers tuned up well enough for a female head pastor, but it will happen someday.
That said, while I agree with this choice by the Lutheran church, some will take this as condoning LGBTQ "activities". Their doctrine still treats it as a sin, and Biblical scholars currently support that doctrine. What this does, though, is recognizes that no particular sin magically makes you unfit to be a member of the church. "For all have sinned...", as the Bible clearly states. It also makes it clear we're supposed to love our neighbors, and doesn't have any exemption clause after that. I'm doubtful the Southern Baptist Convention with it's Fundamentalist leadership will follow suit, but I believe most independent Baptists will soon. I don't know the Catholic policy on it currently, nor do I keep up with a lot of the other denominations.
I won't get into the argument over whether it's a sin or not, that's for someone to argue with the Biblical scholars.