[Python][CI] Remove upper pin on pytest

[AlenkaF]

Describe the bug, including details regarding any error messages, version, and platform.

The latest version of pytest (8.0.0) can't be used on our CI as it breaks couple of things. This issue is an umbrella issue for all needed fixes that would enable the removal of the upper pin on pytest:

• GH-39849: [Python] Remove the use of pytest-lazy-fixture #39850
• pytest-8.0.0 breaks cython doctesting using this module lgpage/pytest-cython#58 (disabling doctest-cython on our CI until the issue is solved upstream). CI failure can be found here: https://github.com/apache/arrow/actions/runs/7710390851/job/21013608732#step:6:6571)
• [Python][CI] S3 fixtures fail with Pytest 8.0.0 #39957

Component(s)

Python

[jorisvandenbossche]

Issue resolved by pull request 40487
#40487