CI: Disable codecov comments and re-enable results in the checks
- [x] closes #26896

Depending on how flaky the coverage calculations are, we could consider adding `threshold` to the yaml to specify how far the coverage can drop while posting success.

https://docs.codecov.io/docs/commit-status

thanks @mroeschke yeah we should figure out what the right coverage report we want.