[Feature][Connector-V2] Upgrade Debezium to 2.7.4.Final

### Search before asking

- [x] I had searched in the [feature](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22Feature%22) and found no similar feature requirement.

### Description

### Context

Seatunnel is currently on Debezium 1.9.8.
This is the first step toward upgrading to the latest version (3.x).
Jumping directly from 1.9.8 to 3.x is too risky, so we're doing this in iteration.
This issue covers upgrading to 2.7.4.Final (latest 2.x LTS release).

Related: #10632

### Why 2.7.4.Final?

- It's the latest stable 2.x release
- More conservative upgrade path from 1.9.8

Once this is stable, we can plan the 3.x upgrade separately.

### Affected Components

- MySQL CDC connector
- Oracle CDC connector
- PostgreSQL CDC connector
- SQL Server CDC connector

### Compatibility Notes

Debezium 2.x should still support MySQL 5.7 but it's not fully tested for this version, so we need to verify this during testing. If there are issues, we'll document and discuss them before merging.

### Next Steps

After this merges and stabilizes, we can open a separate issue for the 3.x upgrade.

### Usage Scenario

_No response_

### Related issues

_No response_

### Are you willing to submit a PR?

- [x] Yes I am willing to submit a PR!

### Code of Conduct

- [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)