[AUDIT] [BUG] [SPARK-49605][SQL] Fix the prompt when ascendingOrder is DataTypeMismatch in SortArray

[tgravescs]

Describe the bug
A clear and concise description of what the bug is.

Spark changed some code in the checkInputDataTypes for SortArray. We have code that is very similar to this so we should look at and see if we need to change and handle similar changes.

Steps/Code to reproduce bug
Please provide a list of steps or a code sample to reproduce the issue.
Avoid posting private or sensitive data.

Expected behavior
A clear and concise description of what you expected to happen.

Environment details (please complete the following information)

• Environment location: [Standalone, YARN, Kubernetes, Cloud(specify cloud provider)]
• Spark configuration settings related to the issue

Additional context
Add any other context about the problem here.