manage_master_user_password_rotation does not disable rotation

Description

It seems that the manage_master_user_password_rotation = false option does not disable the rotation.

Here's my RDS setup:

module "rds" {
  source  = "terraform-aws-modules/rds/aws"
  version = "6.9.0"

  identifier     = "my-rds"
  family         = "postgres16"
  engine         = "postgres"
  engine_version = "16.4"
  instance_class = var.rds_instance_class

  db_name  = local.db_name
  port     = local.db_port
  username = local.db_user
  manage_master_user_password          = true
  manage_master_user_password_rotation = false
  iam_database_authentication_enabled = false

  vpc_security_group_ids = [module.rds_sg.security_group_id]
  db_subnet_group_name   = aws_db_subnet_group.database.name

  allocated_storage = 20
  storage_encrypted = var.rds_storage_encrypted
}

After the RDS is created, the secret has the default rotation of 7 days.

The issue was reported in the past (#547 , #538), but it seems that it doesn't work with the latest version. Also, I tried to fall-back to 6.5.5 since the comments in those issues suggested that it was fixed in there, but still no success.

[X ] ✋ I have searched the open/closed issues and my issue is not listed.

Versions

Module version [Required]: 6.9.0
Terraform version: v.1.9.5
Provider version(s): 5.65.0

Reproduction Code [Required]

module "rds" {
  source  = "terraform-aws-modules/rds/aws"
  version = "6.9.0"

  identifier     = "my-rds"
  family         = "postgres16"
  engine         = "postgres"
  engine_version = "16.4"
  instance_class = var.rds_instance_class

  db_name  = local.db_name
  port     = local.db_port
  username = local.db_user
  manage_master_user_password          = true
  manage_master_user_password_rotation = false
  # password                            = var.rds_master_user_password
  iam_database_authentication_enabled = false

  vpc_security_group_ids = [module.rds_sg.security_group_id]
  db_subnet_group_name   = aws_db_subnet_group.database.name

  allocated_storage = 20
  storage_encrypted = var.rds_storage_encrypted
}

Steps to reproduce the behavior:

Yes

Expected behavior

The secret created by RDS does not have rotation set

Actual behavior

The secret that is created has the default rotation of 7 days

terraform-aws-modules / terraform-aws-rds