The disdain for spreadsheets comes from people who don't understand data organization, or people who do.

Tabular data? Good.
Schemaless? Unstructured? Probably maintained by eleventy-four random sales people and an account? Being given to me like it's a gift and expecting me to just magic it into some reporting system? On a recurring basis? No. Please God no.

I can be trusted to use a spreadsheet for my things that I don't share. Other people need to use something that will yell at them when they give it malformed gibberish.

Oh, and executable logic doesn't belong in the same context as data. That shit needs to be able to be told apart from the data.

Spreadsheets are cool. Where they fall apart they fall apart spectacularly from people insisting on using them as an alternative to a database solution, in my experience. It doesn’t generally matter for normal user centric use cases but I’ve also had to perform a post bankruptcy audit on more than one company that trying to over leverage spreadsheets of duplicate, inconsistent, over saturated, and unreliable data was at the very least a significant contributing factor for the doors being shut.

Over ten contract managers all with their own version of a spreadsheet that tracks reportable items for their contracts and gets rolled up to a master spreadsheet via formulas that financial business decisions gets made from is the first immediate example that comes to mind.

And let's not forget shit! Without shit we'd not have that ancient Sumerian grain! Shit. It's what plants crave!