[Track]: Stabilize external sort

### Is your feature request related to a problem or challenge?

## Background
There are two issues current exist, to prevent external sort to finish stably.
1. https://github.com/apache/datafusion/issues/14692
2. https://github.com/apache/datafusion/issues/14748

After those issues get fixed, we should try to do more comprehensive test through:
1. Enable memory limit in benchmarks and track the failed queries (@ding-young is working on it)
2. Enable the fuzzer test described in https://github.com/apache/datafusion/issues/15517
3. Integrate test https://github.com/apache/datafusion/pull/15727

## Current Status
For the first issue: https://github.com/apache/datafusion/pull/15610 I think this PR can serve as the foundation for future optimizations. I'll merge `main` and polish it over the next few weeks, and also look for someone to help with another round of review.

For the second issue, see related tasks in https://github.com/apache/datafusion/issues/16131.

### Describe the solution you'd like

_No response_

### Describe alternatives you've considered

_No response_

### Additional context

_No response_

Start by reviewing issues 14692 and 14748, along with PR 15610, to understand the external-sort stability work already underway. Then inspect the benchmark memory-limit effort, fuzzer issue 15517, related tasks in issue 16131, and PR 15727. Done means the benchmark failures are tracked, the fuzzer test is enabled, and the integration test is included after the underlying issues are fixed.

Written by the indexing model from the issue text.