https://www.npr.org/sections/parallels/2014/09/09/347093135/...
The story of humans adopting farming is complex, happened multiple times in multiple places, and different societies had very different priorities, methods, and environments to work within. In that context, saying we all did it to get drunk is a bit nonsense.
One of the more interesting things you can read about is how we've found some neolithic settlements that practiced farming for a few centuries, before returning to nomadic hunter gatherer status.
It's pretty clear the primary motivation was simply maintaining caloric intake in changing habitats, not specifically brewing bear, though the Sumarians were quite into that. In fact the oldest remains of what we might call "beer" that have been found were essentially naturally fermented porridge: very thick in consistency. So it seems pretty clear the porridge came first, at least in the Levant.
But probably because you could feed ten times the population, develop better tech, and pound to a pulp any neighbors who didn't follow suit.
However, I recently read something that claimed to debunk this, saying that even 50 proof is not effective at all at sterilizing things and it is merely a solvent for the active ingredients.
The reason I stumbled on it was because I'd been worrying about whether the alcohol free variants are effective, vs. alcohol potentially being a carcinogen.
So I think it's less obvious what effect 1% alcohol has than at first glance.
Nevertheless: https://en.wikipedia.org/wiki/Small_beer