I think the Google Sheets devs would agree with you that spreadsheets shouldn't be used for anything serious. That's why it's missing such basic features as an X/Y scatter plot with a line - which is trivial in any other spreadsheet program.
Personally when I have a few dozen data points and I want an X/Y plot with a line, I find a spreadsheet is a better tool than MySQL.
Yup, I pretty much guarantee that Google Sheets is not intended for people who need X/Y scatter plots. I would theorise that 99% of Excel users don't require that feature either.
Jupyter absolutely includes data visualization, or rather all the major languages it supports do. But honestly, yes. Complicated work in excel is programming, it's just completely undebuggable since the logic is spread out invisibly in multiple grid dimensions, sheets, and macros.
Give me a Jupyter notebook written in a language I don't yet know any day before you give me a complicated excel monstrosity.