Water will drain through sand vertically as long as the sand is raised higher than the water table. It's still going to be wet, but water behavior doesn't lend itself to two levels of standing water. As the water table lowers again following the rainy season, the water in the wet sand will drain into the clay loam of the lake bed and then the sand will dry out.