Fix compatibility with pytest >= 8.4

[youtux]

pytest-dev/pytest#12473 introduced a change that is not compatible with what we currently do to access the original function from a fixture definition.
We should probably use _pytest.compat.get_real_func, but it needs more work, since it also unwraps partials, which we do use as the fixture func, so we need to adjust for that.