docs: Clarify the `manage_master_user_password_rotation` functionality #365

Job	Run time
Collect workflow inputs	5s
Max TF pre-commit	1m 25s
Min TF pre-commit (.)	22s
Min TF pre-commit (./modules/db_instance)	20s
Min TF pre-commit (./modules/db_option_group)	21s
Min TF pre-commit (./modules/db_parameter_group)	20s
Min TF pre-commit (./modules/db_instance_role_association)	24s
Min TF pre-commit (./modules/db_subnet_group)	20s
Min TF pre-commit (./modules/db_instance_automated_backups_replication)	21s
Min TF pre-commit (./examples/replica-mysql)	22s
Min TF pre-commit (./examples/role-association-postgres)	25s
Min TF pre-commit (./examples/complete-postgres)	29s
Min TF pre-commit (./examples/groups)	26s
Min TF pre-commit (./examples/enhanced-monitoring)	22s
Min TF pre-commit (./examples/complete-mssql)	26s
Min TF pre-commit (./examples/s3-import-mysql)	27s
Min TF pre-commit (./examples/replica-postgres)	23s
Min TF pre-commit (./examples/complete-mysql)	22s
Min TF pre-commit (./examples/blue-green-deployment)	22s
Min TF pre-commit (./examples/complete-oracle)	22s
Min TF pre-commit (./examples/cross-region-replica-postgres)	26s
	8m 50s

Provide feedback