I find myself quite conflicted about the Supreme Court ruling. On the one hand, I believe that the free exercise of religion is one of the bedrocks of our nation, and from one point of view, a ruling that affirms this as an absolute right is good and salutary. On the other hand, in a public health crisis it seems there are reasonable restrictions that might be made that in some way inhibit what a church would ordinarily do. This is nothing new; a while back our congregational historian wrote about an incident in 1918 when the rector of our church was arrested because he had failed to follow the flu pandemic restrictions for a funeral he conducted.
So the nub of the issue seems to be what is "reasonable" for safety. I think the complaints about "why is an acupuncture office essential but a church isn't" is really a red herring, and it is unfortunate that the pandemic experts chose the word "essential" (just as many of us wish they hand't used "social distancing"). The real issue is whether churches are being treated differently from "comparable businesses." Not many businesses are really comparable to churches. In an acupuncture office, for instance (just because I'm familiar with this option), you don't have large groups of people sitting in an enclosed space for long periods of time. Same with a retail store. The simple fact is that a church service, as "essential" as we think it is, has many risk factors that most other businesses don't have.
The closest parallel I can think of is a venue like a movie theater. And actually, just looking at California restrictions, the provisions for churches and movie theaters are pretty much the same for the "--outdoor only, with modifications (like masks and spacing). Live theater is completely closed, interestingly--so more restrictive than worship.
I have little patience for the hysteria of people who are trying to claim that "politicians" (especially, of course, Democrats) are trying to "persecute" churches by restrictions that are more onerous than tattoo parlors or liquor stores. Apples and oranges in terms of risk. The "politicians" are listening to the public health people. Do they get it right all the time? No; who does? But crying "anti-Christian persecution" doesn't really help any of us as we navigate an unprecedented situation.
I do tend to agree, though, with those who criticize the "one size fits all" regulations. A building that seats 100 is not comparable to a building that seats 1000, and a rule that says "25% or 25 people, whichever is smaller" is really not well considered.
As an aside, when we were worshiping in person in our fellowship hall, the rule was 25% and then it was 40% for a while when we were in the orange tier. The fellowship hall was built in the 1940s, and there had never been a reason for the public safety people to set an occupancy limit (which happens with any new construction, but usually not otherwise, at least here). So we just ballparked it. When the limit was raised to 40%, we decided that we really couldn't go that high and still be safe, given the configuration of the room. So we basically said, "OK, 25%, but if a few extra people show up, we'll make it work." And an attitude like that is precisely the kind of problem the public health people are dealing with: give some leeway, and somebody will take advantage of it--not maliciously, but just in trying to do what's right but without thoroughly thinking through the implications. (Fortunately, only one Sunday during the four months of in-person did we come anywhere near a problematic number of attendees. The rector that Sunday said "Maybe we need to go to two services"; I said "Let's wait a couple of weeks; I suspect this was a one time issue" which turned out to be right.)