core: `@aws-sdk` dependencies are not being upgraded by the Yarn Upgrade workflow

### Describe the bug

AWS SDK v3 dependencies (`@aws-sdk/*`) are currently not being upgraded.

### Expected Behavior

Their minor versions should be getting bumped during the weekly upgrade workflow

### Current Behavior

The `@aws-sdk/*` package versions are frozen

### Reproduction Steps

Here is the latest PR:

https://github.com/aws/aws-cdk/pull/29703/files#diff-e5ad1bb1515606fb9c8d948c8b920d225ac47584f4cb69124700710c22556f1a

The packages are still on v3.421.0, which was [published 7 months ago](https://www.npmjs.com/package/@aws-sdk/client-s3/v/3.421.0)

### Possible Solution

_No response_

### Additional Information/Context

_No response_

### CDK CLI Version

2.137.0

### Framework Version

_No response_

### Node.js Version

N/A

### OS

N/A

### Language

TypeScript

### Language Version

N/A

### Other information

_No response_

Start with the linked latest PR diff and the weekly Yarn Upgrade workflow configuration; trace why @aws-sdk/* packages remain unchanged. Done means the workflow detects their available minor updates and produces a PR that bumps those dependencies.

Written by the indexing model from the issue text.