`AWS::AppRunner::Service` should fail when update service actually failed but was rolled back by Service

**Community Note**
* Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
* Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do * not help prioritize the request
If you are interested in working on this issue or have submitted a pull request, please leave a comment

**Tell us about your request**
What do you want us to build?

We're building a simple CDK pipeline with `@aws-cdk/aws-apprunner-alpha`. When we misconfigure something, App Runner deployment (update service) fails, for example because wrong port is set.

However, CloudFormation update of `AWS::AppRunner::Service` always succeeds because App Runner automatically rollback to the previous successful revision and `AWS::AppRunner::Service` only sees the final status of the service.

This breaks CDK pipeline's concept e.g. if CloudFormation deployment fails on Staging, it stops promotion there and won't deploy such problematic revision to production.

Ideally, `AWS::AppRunner::Service` should fail when the intended deployment fails on App Runner side.

**Describe alternatives you've considered**
A clear and concise description of any alternative solutions or features you've considered.

No idea.

**Additional context**
Anything else we should know?

N/A

**Attachments**
If you think you might have additional information that you'd like to include via an attachment, please do - we'll take a look. (Remember to remove any personally-identifiable information.)