DOC: Update docs to reflect that Index can hold int64, int32 etc. arrays
Add whatsnew and make doc changes in order to document that `Index` can hold int64, int32 etc. arrays. Removes references to `Int64Index` etc. from the docs.

xref #42717.
I think the ARM failure is unrelated. Nice whatsnew summary!