Looks like 9.0.2 version of Elasticsearch is not compatible with ElasticsearchSinkConnector.
Once I switched to 8.x version (8.12.0) everything started to worked.