REGR: Prevent indexes that aren't directly backed by numpy from entering libreduction code paths
- [X] closes #31223
- [X] closes #31248 
- [X] tests added / passed
- [X] passes `black pandas`
- [X] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`

No whatsnew since this is a regression.