[AWS::Pipes::Pipe] - [Enhancement] - Add Support for MaximumRetryAttempts and DeadLetterConfig Parameters

### Name of the resource

AWS::Pipes::Pipe

### Resource name

AWS::Pipes::Pipe

### Description

Support MaximumRetryAttempts and DeadLetterConfig for AWS::Pipes::Pipe

I have a use case where we created EventBridge Pipes with source DynamoDB and Target as SNS.
We once had a failure where SNS message length was exceeded the limit of 256 KB. It kept on retrying for multiple times and other messages processed also delayed because of this.

We want to configure Maximum retry attempts and DLQ for the pipe.
currently Cloud formation template and CLI are not supporting the Parameters(MaximumRetryAttempts and DeadLetterConfig). we need to manually configure them in AWs console.

https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-resource-pipes-pipe.html

Is there any way of doing this?
Would it be added in any future releases?

I appreciate your support and help.

Thanks
Parimala

### Other Details

_No response_

Start with the AWS::Pipes::Pipe resource named in the issue and review the linked CloudFormation documentation for MaximumRetryAttempts and DeadLetterConfig. Check the repository's coverage-roadmap conventions and any related AWS::Pipes::Pipe entries. Done means the requested parameters are supported and documented for the resource.

Written by the indexing model from the issue text.