[Feature Request]: Automate versions.yml updates using updatecli

[theletterf]

Prerequisites

• I have searched existing issues to ensure this feature hasn't already been requested
• I have tested using the latest version of docs-builder

What problem are you trying to solve?

Currently, updates to versions.yml must happen manually. This adds significant overhead and potential inaccuracies.

Proposed Solution

Use https://www.updatecli.io/ to retrieve current version numbers from mapped repositories. We can add the relevant repository as metadata to versions.yml for easier maintenance.

Examples and Research

The opentelemetry repository uses this strategy for updating version numbers of EDOT:

https://github.com/elastic/opentelemetry/blob/main/.github/workflows/updatecli.yml (done by @v1v)

+CC @bmorelli25 @florent-leborgne @reakaleek

[bmorelli25]

For stack versioned products, I think we want to maintain a manual process for bumping versions. However, I can see how this would be useful for other versioning schemes as engineers release new versions on their own cadence 👍

[reakaleek]

We can still create the automation. Updatecli would simply create the PR.

We still need to merge manually.

[bmorelli25]

Depends on #1497.