I think the average person is actually quite OK!
It's same in the traffic. Most drive just fine, and for that reason, are not observed by others who also drive just fine. Yet the one who crawls in the middle of the road blocking the traffic is the one who's being observed.
It's just that when we see idiotic behavior, our brain tricks us into thinking it's what majority is doing, because that's what we are seeing, it's a kind of selection or sampling bias. In fact, it's just that certain idiotic behavior just sticks out; it's so visible, and yet at the same time, sensible and rational behavior mostly goes unnoticed. This gives the rational people a superiority bias.
It's enough if 1% of the customers shop 2 years worth of toilet paper in one week to cause temporary shortage because the supply chain has been carefully tuned for average consumption. Yet this 1% do not represent average person.
But supply chain can respond to changes, it's not a constant current source. There are many layers all of which have some level of feedback and feedforward available. For example, wheat flour can be, and actually is stored in large amounts; the actual production of wheat isn't a constant current source to begin with. If pasta consumption goes up, plants manufacturing it (from wheat flour) can well respond within a few weeks because it's a simple process. Overall, people don't suddenly start eating more, so yearly consumption is not changed, and long-term wheat storage has no problem supplying the increased demand, because it will be followed with decreased demand when the people are staying home and eating the supplies they stockpiled exactly in the way they planned to, and not buying more. This is all really simple and people are actually behaving surprisingly rationally, avoiding unnecessary shopping when there is a good reason to avoid it.