Elasticsearch storage plugin error on connect to elastic cloud

**Describe the bug**
I have an elastic search cluster inside elastic official cloud and i can't connect to the cluster. When i try to do a `show schemas` for example, i receive the error:
```
ERROR o.a.calcite.jdbc.DynamicRootSchema - Failed to load schema for elastic_prod

java.lang.ClassCastException: null
```

I've launch a elastic single node in my local environment with docker and this elastic single node works perfectly.

**To Reproduce**
1. Create a elastic cluster inside [elastic.cl](https://cloud.elastic.co/)
2. Add this cluster inside apache drill
3. Try to do a query, for example `show schemas;`

**Expected behavior**
It should do the expected query.

**Error detail, log output or screenshots**
```
ERROR o.a.calcite.jdbc.DynamicRootSchema - Failed to load schema for elastic_prod

java.lang.ClassCastException: null
```

**Drill version**
1.21.2
**Additional context**
Add any other context about the problem here.

Start by reviewing the Elasticsearch storage plugin's connection and schema-loading path, then reproduce `show schemas;` against an Elastic Cloud cluster and compare it with the working local Docker node. Check open PR #3025 for existing work; done means Elastic Cloud schemas load without the ClassCastException.

Written by the indexing model from the issue text.