As discussed in #7362 (comment)_, let's change our warnings mechanism to include a new PytestExpiredDeprecationWarning exception which is chosen at runtime depending on the current pytest version.

This will simplify our side because we won't need to change PytestDeprecationWarnings into errors anymore before each major release.