I'd be very content if every chademoidal charger were retired but the charger companies donated me an adaptor instead, but that isn't yet practical at scale. It doesn't (as far as I know) cost much more to provide a CCS2+CHAdeMO dual-cable charger than a CCS2-only single-cable charger. Although the signalling hardware is duplicated for chad, the main cost is the extra cable and plug, especially since CCS2 has had no end of software and hardware comms issues (it uses homeplug(?) power-line Ethernet, and needs filters and such to make sure it doesn't accidentally connect to another car plugged into the next door charger, where chad uses a much simpler point-to-point wired CAN bus).
At present, though, there are far more chademoidal cars than chargers. If the adaptors cost about the same as the second cable on a charger, the total cost would be much higher to provide all the affected cars with adaptors than to maintain the plugs on the chargers. I'm not sure how many rapid charger sites there are -- maybe a thousand or so -- but there are very roughly 70,000 Leaf, e-NV200 and oddments registered in the UK. Round figures are 59,000 Leaf, 9,200 e-NV200, and a few of other models [data from howmanyleft.co.uk]. That's not a large market, but it's enough customers to be worth keeping -- I'm not keen on Ionity, Tesla, or Applegreen, for example, because they have made it clear by ignoring chad that they don't want my custom. (Not keen on Tesla for the obvious other reason, too.)
No-one is producing any new CHAdeMO vehicles for the UK. All new models of EV are required to use CCS2 (or Type 2 if they don't have rapid charging at all). This isn't a commercial VHS-like take over, it's a regulation by decree which car makers have to meet. But the existing cars, or most of them, will be on the roads for years yet: Leaf has a reputation for reliability apart from its battery degradation. A few chads will be imported from Japan.
An adaptor for £300 would be an easy purchase for me to justify. Much cheaper than a new CCS-equipped EV with the good features of my little red van-with-seats, and nice to have for peace of mind.