Fog is because the sun is mostly blocked by higher water vapour. It can heat the ground up enough to warm it and release vapour but not enough to force the water vapour into the upper hemisphere.
However, for a 5yo I agree that the "a cloud that can't fly" is a very good answer !