My starting point would be that in their absence, a lot of problems wouldn't have been solved with computers, for want of programmers.
It's the lowest-barrier programmable logic, a coordinate-system where arithmetic can be applied to contents of any given coordinates.
And it likely would have grown into the same exact mess as Excel, with continuous expansion of the arithmetic part, as people kept reaching the limits of it but wouldn't go back and recreate everything in a DB...
IBM buying Lotus and not Word Perfect was probably a mistake, had they really wanted to take it seriously... but they seemed more interested in Lotus Notes (think Outlook+Access in a self-hosted cloud environment), it was imho nasty af.
What frustrates me the most about this is I've seen some insane excel wizardry from the accounting department at various jobs over the years that is effectively programming, and that if these people had put just as much effort into learning Python & using a database, they'd be better off and might actually make good developers. In my view, Excel ends up becoming sort of an artificial barrier to departments outside of IT being able to make business software.