Demand is low at night, but many types of power plants are not easily/efficiently throttled down for lower supply (e.g.: nuclear, wind). So it makes sense to use the extra supply to pump water up.