Also, the more the personal transportation fleet electrifies, the more electricity we will need during the night/evening: everyone will want their car/bike/scooter/autogyro ready for commuting in the morning.
Transportation charging at night will be a drop in the ocean, something like 10-15% of our total energy needs, much of it happening during the day time. If half of vehicles are charging for a few hours of the night night, that's a couple percent of night time demand coming from transportation. A couple percent, maybe maxing at 3-5%, will be far less of a worry than the double digits required by home heating and electricity or industry or agricultural needs.