"the most exciting kind of non-volatile memory – a bold attempt to bypass a whole pile of legacy bottlenecks and move non-volatile storage right onto the CPU memory bus – flopped. It was killed by legacy software designs."
No, that wasn't what killed Optane.
What killed it was the shrinking gap between the performance that it offered vs. SSD in improving form factors like M.2 NVME.
There was software being written to exploiit optane, and it would have worked great -- but the number of applications that desperately need it was small compared to the ones that were perfectly happy with mmapped nvme ssd. Intel saw that trend and decided they couldn't afford to keep that ship operating. Now, there's plenty of things that could use mmapped files that don't, but that's another story.
It's sad, because it was interesting, but it wasn't really the legacy designs. It was the lack of clear advantage with other things getting faster.