[Tech debt] Add automation to auto-generate core_types_pb2.py on branches

[MichelleArk]

Housekeeping

• I am a maintainer of dbt-core

Short description

Currently we use make core_proto_types locally to generate the core_types_pb2.py file locally and push that up as part of a PR that introduces proto changes. This means developer versions of protoc can differ locally and result in inconsistent versions used to generate the file.

Instead, let's create some GH automation that generates the file and commits it to a branch if it detected changes.

This can use protoc 5.26.1 for now (will need to be installed from source) until #10658 is closed.

Acceptance criteria

GH automation that generates the file and commits it to a branch if it detected changes.

This can use protoc 5.26.1 for now (will need to be installed from source).

Suggested Tests

n/a - GH automation

Impact to Other Teams

n/a

Will backports be required?

nope

Context

No response