[REQUEST]: Port AutoOps doc updates from Cloud

### Description

Port https://github.com/elastic/cloud/pull/138855 from the Cloud repo.

### Resources

https://github.com/elastic/cloud/pull/138855

### Which documentation set does this change impact?

Elastic Cloud Hosted only

### Feature differences

N/A

### What release is this request related to?

N/A

### Collaboration model

The documentation team

### Point of contact.

@alaudazzi 
