Enable `split_file_groups_by_statistics` by default

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

- Part of https://github.com/apache/datafusion/issues/10313

In https://github.com/apache/datafusion/pull/9593, @suremarc added a way to reorganize input files in a ListingTable to avoid a merge, if the sort key ranges do not overlap

This feature is behind a feature flag, `split_file_groups_by_statistics` which defaults to `false` as I think there needs to be some more tests in place before we turn it on

### Describe the solution you'd like

Add additional tests and then enable `split_file_groups_by_statistics` by default

### Describe alternatives you've considered

_No response_

### Additional context

_No response_