> the presumably high % of their business that came from tourists

That's only in the areas frequented by tourists. The vast majority of such tiny bars cater mainly to locals.

Lately I've been taking pictures of bar signs in Japanese cities:

https://gally.net/barsigns/index.html

The sheer number of bars in such dense concentrations continues to impress me.