Nope, it won't (at least in the system used in the U.S.). The thermal time constants of the transformers supplying residential power is quite long, a day or so. During the day, when demand is high, they heat up. Part of designing the distribution system is to balance the heat generated during the day with the cooling available at night. If the night-time load goes up, then there's not enough cooling time, and the transformers catch on fire.