[backport 2.3.x] CI: remove usage of legacy NPY_PROMOTION_STATE (#60144)
Backport of https://github.com/pandas-dev/pandas/pull/60144
Failures look unrelated, Windows is failing with some XMLSyntaxError in the html tests (maybe temporary flake?). And there is one failure in the string test build that we should look into, but will do that separately.