[ArrayManager] TST: run (+fix/skip) pandas/tests/frame/indexing tests
xref #39146

Extracting part of the test changes of https://github.com/pandas-dev/pandas/pull/39578. This PR is doing `pandas/tests/frame/indexing`. The `pandas/tests/indexing` tests are handled in https://github.com/pandas-dev/pandas/pull/40323.
