Adapt to the removal of codecov PyPI package in CI

[teojgo]

The ci should be adapted to the new functionality: https://about.codecov.io/blog/message-regarding-the-pypi-package/

[vkarak]

Bumping the priority as this is now blocking all PRs (it's a required workflow). If we can't fix this soon, we should temporarily disable the codecov workflow.