Your point is really interesting, I've seen similar articles and I still can't figure out why and how spreadsheets could be replaced by Jupyter Notebooks.
While they are awesome for data analysis and building code by section, to the best of my knowledge the sequential execution lacks the flexibility of the dynamic interdependence of spreadsheets, so having the possibility to call dynamically Python code seems awesome to me in the context with several interconnected variable as it allows quick, simple and dynamic modeling.
Am I missing something?