Upgrades upstream from v5.39.1 to v5.40.0.

Fixes https://github.com/pulumi/pulumi-aws/issues/3592

Reasons an automated upgrade did not succeed:

- Failed: 0045-Fix-job-queue-sdkv2-migration
- Failed: 0039-Restore-legacy-bucket.patch (go.sum conflict)
- pulumi/terraform-plugin-framework needed updating to use v1.6.1
- aws_securitylake_subscriber resource based on Plugin Framework needed
its tags_all patched