The article you linked doesn't really back this up, at least in the way this discussion means it. It shows that with flexible production, you can drastically scale back on "traditional" base load power sources, and that is representing a real power grid in Germany. Nothing about the graph actually says "this is as much renewables as you can pack into this power grid".
If you look at the graph closely, you'll notice that solar is big during the day, and wind is big during the night. With greater installed wind production capacity, the fossil fuel lines would drop drastically in the graph. It's that simple. We would still need to have "peaker plants" available until there is enough grid energy storage capacity, but combined cycle natural plants work fine for that. We can keep pushing down the time they need to on by building more renewables even without batteries.
> The storage facility you linked to was the biggest facility in the world when it was first constructed, and it stored only 129 MWh of electricity.
I specifically linked that one because it talks about how ridiculously profitable it has been, and how much of an impact it has had on the local grid. If it can save money for a traditional grid, then it is a no-brainer for utilities to install bigger and bigger grid batteries. More demand for batteries means more battery production facilities, increasing global production capacity over time.
However, the world is also transitioning to Electric Vehicles, and most EV manufacturers are offering V2G (vehicle to grid) solutions, so millions of EVs can contribute a portion of their battery capacity to the grid in the future, and the grid can compensate them for their contribution.
> Battery production is expected to increase, but it's unclear whether raw material inputs can keep up with manufacturing demands [2].
Lithium is not exactly rare or hard to extract, you can even extract lithium from saltwater, so this argument seems specious. But, various alternative chemistries are being explored which could help in different ways.
> At our current rate of battery production it'd take us a century of dedicating 100% of our battery output to grid storage to reach 1 day's worth of storage.
How did you determine that we need a full day's worth of energy storage? We can drastically decarbonize the grid (and lower electric costs for consumers) with a lot less than that, based on what I've seen, but this is a highly speculative part of the discussion so it's interesting to hear how that number came to be.