In a way if people can’t yet use spreadsheets correctly (but they think they do) then it’s impossible to move them away.

Also the OP has much about the programmatic components, but Excel is also an interface. The front end of an unofficial corporate app. And people know (they think) how to use it.

I just listened to a demo of an insurance industry SaaS that isn’t yet public. Goal to move many things out of spreadsheets. Had AI agents built in and all sorts of bells and whistles. But the screens were chaos. I immediately thought it was just too “complicated” to switch a person off the busy/messy system they know - Excel.