Couple of years ago clickhouse wasn't that good with full text search, to me that was the biggest drawback. Yes it's faster and can handle ES scale but depending on your use case it's way faster to query ES when you do FTS or grouping without pre-build index.

How much RAM does Elasticsearch need for fast full-text search over 100 petabytes of logs? 100 petabytes is 100 millions of gigabytes, just in case.