When Bill Gates says:
"There's no battery technology that's even close to allowing us to take all of our energy from renewables and be able to use battery storage in order to deal not only with the 24-hour cycle but also with long periods of time where it's cloudy and you don't have sun or you don't have wind."
he's totally wrong.
For starters, there's Vanadium Redox. A flow battery (pumped electrolyte): Power limited by the size of the reaction device's electrode and membrane assembly. Energy storage limited by the size of the tanks. It's mainly used for utility-level energy storage down under (Oz or Nz, I think), because the patents are still fresh and the little startup doesn't want to license it to others. Vanadium is some substantial percentage of the Earth's crust so there's no shortage. Using the same element (in different sets of oxidation states - vanadium has (at least) 6 of 'em) for BOTH electrodes means leakage of small amounts of the element through the dilectric membrane doesn't poison the battery.
Lithum cells are already good enough to run laptops, cars, and houses, and are improving at a Moore's Law like rate. The elements are also not rare and the use of several nanotech techniques on the electrodes have drastically increased the lifetime and other useful properties. (We just had reports of yet another breakthrough within the last day or so, doubling the capacity and extending the life.) The fast-charge/discharge cells are also extremely efficient. (They have to be, because every horsepower is 3/4 kW, so even a few percent of loss would translate to enormous heat in an automotive application.) The main problem is to get companies to "pull the trigger" on deploying them - and risk their new production line being rendered obsolete before the product hits the market by NEXT month's breakthroughs.
Lead-acids need to be replaced once or twice per decade. But they have been the workhorses for off-grid since Edison's and Nikola Tesla's days, and still are today (though not for long, if Elon Musk and the five billion dollars of investments in his lithium battery plant have anything to say about it).
Nickel-Iron wet cells are a technology developed by Edison. They have more loss than lead-acids. But they literally last for centuries. If you have a moderately steady renewable source (like some combination of enough wind and a big enough windmill, enough sun and a big enough solar array, or a stream and a big enough hydro system) you'll have enough more power than you need to keep them topped off. They're just fine for covering days, or even a couple weeks, of bad generation weather, or down-for-maintenance situations. That IS what they were in at least one hydro plant I know of. (The problem is finding them: They last so long you only need to buy them ONCE, so there aren't many plants.)
That's just four FAMILIES of entirely adequate solutions. There ARE more.
So Bill is either uninformed, talking through his hat, or starting on the "embrace" stage of yet another: