[Prometheus Input]: Change Prometheus Input to TSDS

### Integration Name

Prometheus Input [prometheus_input]

### Dataset Name

_No response_

### Integration Version

1.0.0

### Agent Version

9.2.0

### OS Version and Architecture

Container on EKS

### User Goal

I would like to use the full set of time series aggregation features in ES|QL against the metrics we are ingesting from Kubernetes components via the Prometheus Input integration.

### Existing Features

We are not able to use the time series aggregation features in ES|QL as Prometheus Input Data Streams are not configured with index.mode set to time_series.

### What did you see?

When attempting to change the existing data streams to time series, data ingestion fails with the message "Error extracting tsid: source didn't contain any dimension fields"

### Anything else?

https://www.elastic.co/docs/reference/query-languages/esql/functions-operators/time-series-aggregation-functions