python: promote long tail of 0.x packages to 1.x

There is a long tail of libraries that are still version `0.x` with a stable api channel in the client that should be promoted to `1.x`.

While our policy dictated new libraries, even those with a `v1` stable API version, start with version of `0.x` and "bake" for some period of time before promoting to `1.x` version, this was never automated.

Similar to https://github.com/googleapis/librarian/issues/5303#issuecomment-4407411833, we need to analyze the `google-cloud-python` repo and determine which libraries can be promoted to `stable` and `1.x` versions.

Start by reviewing the google-cloud-python repository and the comparable analysis in the linked librarian issue comment. Done means identifying which 0.x libraries with stable API channels qualify for promotion to stable and 1.x versions, with the resulting scope clear enough to guide automation.

Written by the indexing model from the issue text.