### Elasticsearch Version

main

### Installed Plugins

_No response_

### Java Version

_bundled_

### OS Version

Darwin

### Problem Description

Sorting fails sometimes with the error

```
No TopN sorting encoder for type UNSUPPORTED
```


### Steps to Reproduce

Playing with ES|QL I tried to run the following query

`from logstash-* | sort extension.keyword`

This returns the error

```
No TopN sorting encoder for type UNSUPPORTED
```

If I run the query:

`from logstash-*  | keep extension.keyword | sort extension.keyword`

the data return successfully.

### Logs (if relevant)

_No response_
x-pack/plugin/esql/compute/src/main/java/org/elasticsearch/compute/lucene/ValueSources.java
new ValueSourceInfo(
                        new UnsupportedValueSourceType(fieldType.typeName()),
                        new UnsupportedValueSource(vs),
                        elementType,
                        ctx.getIndexReader()
                    )
                );
            } else {
                sources.add(new ValueSourceInfo(vsType, vs, elementType, ctx.getIndexReader()));
            }
        }
        return sources;
    }
    private static ValueSourceInfo unsupportedValueSource(
        ElementType elementType,
        SearchExecutionContext ctx,
        MappedFieldType fieldType,
        IllegalArgumentException e
    ) {
        return switch (elementType) {
            case BYTES_REF -> new ValueSourceInfo(
                new UnsupportedValueSourceType(fieldType.typeName()),
                new UnsupportedValueSource(null),
                elementType,
                ctx.getIndexReader()
            );
            case LONG, INT -> new ValueSourceInfo(
                CoreValuesSourceType.NUMERIC,
                ValuesSource.Numeric.EMPTY,
                elementType,