Support for pytest 8.0.0+

[Taragolis]

Body

New version of pytest 8.0 by default will raise an error for PytestRemovedIn8Warning need to be sure that we do not use this deprecated stuff

Known dependencies which are limited < 8.0

• pytest-asyncio: Support for Pytest 8.0 pytest-dev/pytest-asyncio#737

Committer

• I acknowledge that I am a maintainer/committer of the Apache Airflow project.