I am more of a business type that works with data, I've messed around with python and it's not really a spreadsheet application.

The power of Excel is that it is a "pick up and use" solution (including for more complex use cases).

I've also had some terrible experiences with the Python infrastructure (dependency conflicts, borked installations) for some non-work projects.