and overnight renders all the investment and infrastructure thats been built for J1772/CCS Type1/2 completely pointless and wasted effort almost overnight.

I could be mistaken, but I don't think it's that grim. J1772 will still be good for supporting vehicles and locations that don't support DC charging. Level 2 will continue to be useful for years since the grid doesn't support Level 3 charging just anywhere.

And CCS 1/2 will support NACS with relatively simple adapters as I understand it. Existing DC charging stations can simply replace their CCS 1/2 ends with NACS over time when they would be replaced for maintenance anyway, and perhaps provide adapters in the meantime.

I highly recommend this video from Technology Connections which changed my mind about this.

(To be fair, as an owner of a PHEV that can't use DC charging anyway it doesn't make much difference to me though.)