The eye clearly has frequency limitations, so we just need to find the sampling strategy which accurately codes all perceptible frequencies.
In an ideal world, we would also be using hexagonal grids rather than square, which gives a resolution increase for the same area and a given pixel size, and also reduces off-axis aliasing.
As for hexagonal grids, there are a number of complications introduced by that, especially when it comes to using general algorithms based on regular 2D euclidean space.
Agreed about the complications of the hexagonal grid. We make implicit assumptions everywhere. Though I'm not sure they are insurmountable for some purposes; with graphics APIs like OpenGL, texture coordinates and samplers could be using a hexagonal grid relatively transparently. That would allow use of hexagonal displays even if the texture data is square.
The eye clearly has frequency limitations
No...the eye doesn't work that way. It is not a machine. It is organic and analog. It doesn't have some frequency limit. In any case, you're abusing the Shannon-Nyquist theorem. It absolutely does not imply that if some device is sampling at x hz then you can sample at 2x hz and produce a sufficient reproduction for the 1x hz sample. This is a common misconception.
This is really the fundamental problem with saying "X ppi is enough for the eye" or "you can't see faster than X Hz". This is a digital approach to an analog system. Your brain is tuned to identify resolution in the center of your vision and movement in the periphery, and has all kinds of "special case" circuitry to react quickly when necessary.
Classic example, fighter pilots are capable of recognizing silhouettes flashed on a screen at some ungodly rates. But if you were, say, playing a game, 100 Hz is very smooth already (even CounterStrike), and you might not be able to visually distinguish that from 144 Hz.
It's like a psychovisual model with a temporal aspect incorporated.