Proposals for bridging the Straits of Gibralter, Norway's E39 project, the EU project as a whole, and Energiewende (and its various national counterparts) would also strike me as major forward-thinking endeavours.
________________________________
Notes:
1. My focus is on technical rather than economic success here, though each project mentioned here did go operational, and all but Conocorde remain so. Economic viability is a challenge for most megaprojects.
Really ambitious technical things by their very nature have uncertain outcomes and may prove spectacular, or even slow-motion failures. Concorde was only very barely commercially viable (if that) and ultimately exhibited fatal engineering flaws, as well as susceptibility to alternative (though slower) private jets with more flexible scheduling. The Channel Tunnel would have bankrupted the corporation building and operating it (Eurotunnel) without government bailouts.[1] The Airbus A380 has similarly proved a commercial failure with production halted at 254 units built in 18 years, compare against Boeing's 747 with 1,574 units over 55 years.
Even accepting your characterisation of Energiewende as a failure, which I do not, it absolutely IS a "really ambitoius technical" project. And hence refutes the specious assertions of ur-whale.
________________________________
Notes:
1. "Megaprojects and Risk: An Anatomy of Ambition" <http://www.josephcoates.com/pdf_files/268_Megaprojects_and_R...> (PDF)
https://www.euronews.com/next/2023/09/16/the-high-speed-rail...