[Kubernetes]: Overview dashboard visualizations break if Elasticsearch node does not have "remote_cluster_client" role.

### Integration Name

Kubernetes [kubernetes]

### Dataset Name

_No response_

### Integration Version

1.70.2

### Agent Version

8.14.x

### Agent Output Type

elasticsearch

### Elasticsearch Version

8.14.x

### OS Version and Architecture

RHEL 8.x

### Software/API Version

_No response_

### Error Message

node [NODE NAME] does not have the remote cluster client role enabled

### Event Original

_No response_

### What did you do?

Used default integration configuration.

None of the Elasticsearch nodes have the "remote_cluster_client" role.

### What did you see?

Cannot provide screenshots or logs from our airgapped cluster. Our error is exactly as shown on this Elastic discussions page:
https://discuss.elastic.co/t/remote-cluster-client-error-on-kubernetes-overview-dashboard/355874

### What did you expect to see?

For the dashboard visualization to work even on a cluster that does not have CCS enabled.

### Anything else?

This appears to have started with this PR when the index pattern was changed to `metrics-*,*:metrics-*`
https://github.com/elastic/integrations/pull/6933