It's exactly why I built xlwings, to replace VBA with Python. Python in Excel instead is a competitor to the Excel formula language.
If we are going to open up Jupyter notebooks, we have already failed.
(That's why VBA works, it's the only thing that runs on locked down corp laptops, because it's inside Excel.)