You generally are expected to deal with slight unpleasantries when in public. For example you are not guaranteed to be seated at a table without kids around, without dogs around, without wheelchairs, strollers, or walkers nearby. The table next to you might be talking loudly or celebrating a birthday.
If those things bother you, eat at home.
Service animals are the exception, and I'd certainly never begrudge anyone the companionship of a seeing-eye dog.
Unfortunately, though, it feels like this exception has been abused as more people take on pets for nebulous "comfort" roles, but service animals are strictly defined; many establishments may not wish to risk offense by questioning that in the moment.
Edit: apparently the FDA has updated their guidelines to allow pets as of last year.
There was a meal-prep service nearby with a storefront open to the public. I visited a few times, and the owner had a pair of dogs who were free to roam the floor. Their names were "Cash" and "Charge". That was one of the factors that helped me decide I should not continue to patronize them.
For plenty of people a dog has become a substitute for a child to some extent and those people often refuse to acknowledge that it's still a dog, an animal. Conversation can get heated and emotional very quickly in such case.
I'd venture that badly-behaved dogs can be filed under "rowdy".