Hi Gilbert,
This is in dry, windy Colorado, so evaporation will not be a problem.
Well, not having enough shouldn't be a problem! Is there a potential for too much?
Where does the water come from? Figure ~1' diameter for your buckets... is this big enough? And at that size, are we talking a 20' trench? A 50' trench? Starts to turn into a lot of pots and insulated lids if you have a large customer base!
How much water will a trench of whatever length evaporate? How far do you have to run a hose or carry a bucket to replace it? Still have plenty of water onsite by September?
I'm a bit skeptical of the physics here... With only the bottom 6" in the damp sand, these big pots would have a lot more surface area exposed to the hot, dry wind than to the cool, damp sand. Seems like the key would be for the pots to wick up enough moisture to play a major role in the cooling process; will they? Otherwise that upper portion is just a heat collector... While this worked for amphorae way back when... IIRC those were relying on seepage from inside.
I would expect that shading this whole setup would be important. I guess the thing I like best about this idea is you can easily test it out in a 1-pot size!
Possible alternative, if there's suitable ground and equipment; what about some sort of free-standing, earth-insulated pantry/shed, painted white and cooled with earth tubes?
http://massmind.org/techref/other/spac.htm#Vent