Great question!
Here's what Germany did: They invested a vast amount in local renewables, at above market prices, that had the effect of dramatically driving down the global price of wind and solar. Because they radically expanded production capacity. Effectively, Germany gave the world a 'gift'!
This had the long-term affect of dramatically increasing global solar + wind deployments (b/c prices fell) and transferring a huge economic boom to China, who actually made the solar panels and who's government subsidized production.
Unfortunately, for domestics political reasons, Germany also shut down their nuclear plants and kept burning coal. So their total CO2 emissions have been roughly constant and about 10x higher, per person, than France or Sweden.
The article is correct in that vastly more electrical transmission is needed to effectively integrate renewables. The article is misleading in describing price spikes. Yes, there are 2-45 days a year of price spikes for a few hours, but on average price is lower b/c of renewables outside of Germany. (Again, Germany did everyone the favor of buying renewables before they were economic.) Texas average prices are some of the lowest in the world. CA wholesale power prices are very low globally, while retail prices are sky high b/c PG&E is a monopoly combined with an inadvertent domestic terrorist organization.
Something the article only eludes to, the energy transition covers many more areas than just power production. Germany has done a bad job in both transportation and building emissions. They're overly reliant on Russian natural gas for heating and have been slow to embrace electric cars (VW is doing 'ok' but not great). Both issues are separate to renewables but major failings of German policy to either reduce emissions or increase energy security.
Overall, the German investment in renewables electricity production is a massive success and global gift. Completely underrecognized. Everything else sits in the category between "failure" and "didn't even try."