ElasticSearch Sink to use sink_decouple by default

[kwannoel]

So it can isolate sink job failure.

[kwannoel]

Generalizing this further, which sink should have sink_decouple set and which should not? What's the criteria? cc @hzxa21 @xxhZs

From our docs it seems like some support sink_decouple, and others do not. Why don't we enable it for all sinks that support sink_decouple?

https://docs.risingwave.com/docs/current/data-delivery/#sink-decoupling

[github-actions]

This issue has been open for 60 days with no activity.

If you think it is still relevant today, and needs to be done in the near future, you can comment to update the status, or just manually remove the no-issue-activity label.

You can also confidently close this issue as not planned to keep our backlog clean.
Don't worry if you think the issue is still valuable to continue in the future.
It's searchable and can be reopened when it's time. 😄

[xxchan]

#17095