My sister asked me this question and I keep thinking that water would conduct heat much faster than sand. Hence the energy transfer of heat across the lake does not allow it to heat up soon. Sand on the other hand is probably a bad conductor of heat and hence more heat energy is held up by each grain of sand.
But then with water there is also convection which perhaps plays a role.
I would like to see what the experts say. My thinking is quite informal.