For them, it's a database with a UI and a chart module.

As someone in the generation mentioned in the OP meme I can confirm, most people in my generation don't know how to use Excel either, didn't know it when we were younger and that is mostly because it is largely used in professional settings for a narrow range of jobs for its actual purpose and everyone else in a slightly wider range of jobs would be better off using a web app with an actual database.

I've met software developers who didn't know how to use Excel properly (in the sense of not even knowing they could use formulas).

I think that's very much for the reason you state: they "won’t go out of their way to learn a software they don’t even know they will use".

It's not just a "common man" thing, it's an everybody thing - there's just too much stuff and not enough time to learn it all, so even software developers might never find themselves in a situation were they have to understand Excel enough to know such simple things as how to use functions in the cells, how to use references to other cells or how to make some references be relative to a cell's position and other absolute.

Mind you, they'll probably learn it way faster than "common" people simply because so much of its advanced usage follows "programmer logic", but that still requires them to be forced to actually use it long enough and often enough that they put the effort into learning it.