As previously mentioned, I like dogs just fine. I grew up with them, and I'll pet a friendly one on the street. But I really don't think they belong in restaurants, bars, or grocery stores, and I say this as someone without any particular fear or dislike of them.
I guess the main issue is hygiene. These are places where food is being prepared, served, or sold. Dogs walk on floors, shed, drool, and, yes, sometimes have accidents. Even the cleanest, best-behaved dog is still an animal that licks itself and sniffs things we'd rather not think about. In a grocery store where produce sits in open bins or where people are selecting fresh bread, that's just not sanitary. I was at Trader Joe's yesterday, watching a beagle stick its nose into everything at ground level. To your point, that's the owner's job to manage, but it certainly wouldn't be happening if the dog wasn't there to start with.
Then there's the fact that not everyone wants to be around dogs while they're eating or shopping. Some people are allergic. Some are genuinely afraid. Some have religious or cultural reasons for avoiding dogs. And some people just want to enjoy their meal or get their groceries without having to navigate around animals. A restaurant or store should be a neutral public space that accommodates everyone.
I also think the normalization of dogs everywhere actually makes things harder for people with legitimate service animals. When every third person has their pet in a store, it creates confusion and skepticism about who actually needs their animal for a medical reason. I'm at the point where I am doubting EVERY service animal I see because there are so many of them now, kind of like how I am a skeptic about people who park in handicap spots. I don't like to be that way, but because it's so much more ubiquitous than it was in the past (at least in South Florida, where I live), my attitude has changed from empathy to skepticism.
There are plenty of dog-friendly patios, parks, and outdoor spaces. Keeping indoor food establishments animal-free seems like a reasonable line to draw.