SNOW-1478684: Remove index.equals workaround from compare

[sfc-gh-nkumar]

1. Which Jira issue is this PR addressing? Make sure that there is an accompanying issue to your PR.

   Fixes SNOW-1478684

2. Fill out the following pre-review checklist:

   • I am adding a new automated test(s) to verify correctness of my new code
     • If this test skips Local Testing mode, I'm requesting review from @snowflakedb/local-testing
   • I am adding new logging messages
   • I am adding a new telemetry message
   • I am adding new credentials
   • I am adding a new dependency
   • If this is a new feature/behavior, I'm adding the Local Testing parity changes.

3. Please describe how your code solves the related issue.

   This bug is no longer reproducible. Possibly due to recent changes in Index.equals (https://snowflakecomputing.atlassian.net/browse/SNOW-1458148). This PR adds the new test as validation before closing the issue.

[sfc-gh-mvashishtha]

Thanks! Should we also remove this workaround for the bug:

snowpark-python/src/snowflake/snowpark/modin/plugin/compiler/snowflake_query_compiler.py

Lines 15947 to 15951 in 3e34c76

	# TODO(SNOW-1478684): Stop calling to_pandas() to work around Index.equals() bug.
	def pandas_index(index: Union[native_pd.Index, pd.Index]) -> native_pd.Index:
	if isinstance(index, native_pd.Index):
	return index
	return index.to_pandas()

[sfc-gh-nkumar]

Thanks! Should we also remove this workaround for the bug:

snowpark-python/src/snowflake/snowpark/modin/plugin/compiler/snowflake_query_compiler.py

Lines 15947 to 15951 in 3e34c76

	# TODO(SNOW-1478684): Stop calling to_pandas() to work around Index.equals() bug.
	def pandas_index(index: Union[native_pd.Index, pd.Index]) -> native_pd.Index:
	if isinstance(index, native_pd.Index):
	return index
	return index.to_pandas()

Done!