[cloud] Fixes #24578: ROLLBACK_COMPLETE is a failure state for CloudFormation module (#24596)
[cloud] Fixes #24578: ROLLBACK_COMPLETE is a failure state for CloudFormation module (#24596)

* ROLLBACK_COMPLETE is a failure state

Fixes #24578

* Adding AWS documentation on Stack status

* Fixed comment

thaim/ansible,thaim/ansible