[Spark 4.0.0] Cast in ANSI mode uses wrong exception class

### Describe the bug

Test:

```
SPARK-39175: Query context of Cast should be serialized to executors when WSCG is off
```

Error:

```
ex.isInstanceOf[org.apache.spark.SparkNumberFormatException] was false
```

### Steps to reproduce

_No response_

### Expected behavior

_No response_

### Additional context

_No response_