This one really has me scratching my head. Luckily I had plenty of KNIME compatible conda environments on hand so that I was able to simply pick one and at least for now I can work with Python in KNIME again.
I took some time to investigate further:
I noticed this instruction in the settings to enable the bundled env:
Both the guide and the instruction point to Python Integration Extension, which I have already installed in the correct version: