Do you see there being a realistic alternative?

I realize we can't really go backward in time, but I would prefer if the farmers that lived close to where I am sold to people who live local to me. That can happen to some degree (open yard stands), and I like to do that for some of the smaller farms, but it's really a kind of "nice to have" rather than a "The market stocks stuff that was grown a town or two over" type thing. I feel like something probably got lost when that kind of arrangement went away.

There's still one or two local businesses that manage to make it into the local market for me which is neat to see, but that's more so because they are for frozen pastries and stuff, and can prepare a metric ton in advance, and the market can mark it up for being a "local specialty" type thing. I like to buy them when I can afford it. It just sucks that essentially every other thing on a shelf probably wasn't even made in the same time zone or hemisphere.

Why do we need an alternative? Your preferences don't matter.

The thing you imagine has never really been true. Rivers, seas and canals and later railroads and highways have always brought food to the city from as far as it could be transported before it spoiled.

Rome got its wheat from Egypt and its olive oil from around the Mediterranean.

Ancient egypt sent food up and down the nile to population centers in Cairo and Thebes.

And so on.