[ES|QL] report all accepted types during parameter validation

[drewdaemon]

Describe the feature:

We only report one type possibility in arg-type validation error messages even if more than one type is acceptable.

For example, Argument of [st_y] must be [cartesian_point], found value ["a"] type [string]

But, actually, st_y accepts a parameter of type cartesian_point or geo_point.

Instead, it would be better to report all accepted types:

Argument of [st_y] must be [cartesian_point, geo_point], found value ["a"] type [string]

[elasticmachine]

Pinging @elastic/kibana-esql (Team:ESQL)

[drewdaemon]

I went with impact:medium because I could see this being confusing. Feel free to adjust, @stratoula!

[drewdaemon]

Closing in favor of the more comprehensive issue: #180518