[AWS] Update AWS provider to version 6

[felixglezprefapp]

Motivation

We need to update our AWS modules to use the latest version of AWS provider. At the opening of this task, latest version is 6.32.0.

Acceptance criteria

To ensure that there are no conflicts, the following tasks must be carried out for each module:

• Create a subtask for each of the modules in the "Review & Update" section.
• Check the latest official version and possible conflicting changes in the changelog.
• Check the good functioning of the module with the updated version.
• Merge the PR of each module by triggering the release-please workflow with feat!

Review & Update

• aws-sso
• aws-vpc
• aws-cloudfront-delivery
• aws-ecs
• aws-oidc
• aws-rds
• aws-secretsmanager-replication
• aws-terraform-backend
• aws-waf

References

https://registry.terraform.io/providers/hashicorp/aws/latest
https://registry.terraform.io/providers/hashicorp/aws/latest/docs/guides/version-6-upgrade

@see #88