STYLE: Enable unnecessary list index lookup
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).

Associated with #48855.  Enables the Pylint type "R" warning `unnecessary-list-index-lookup`.  Also updates the list of intentionally disabled checks.

@MarcoGorelli , are you talking about the changes to `pyproject.toml`?  I took the liberty of updating the list of intentionally disabled warnings: `wrong-import-order` appeared twice in the list, while `broad-except` and `overridden-final-method` were in the list at the top of #48855 but not in the section for intentionally disabled warnings in `pyproject.toml`.

If you'd like, I can change them back. ah, that's fine then, thanks for explaining!