[AWS::Events::Rule] - [BUG] - EventBridge Rule drifted if using Dead Letter Queue (SQS DLQ)

### Name of the resource

AWS::Events::Rule

### Resource Name

_No response_

### Issue Description

CloudFormation still returns "drifted" when a Events::Rule has a DLQ. I created an issue #1605 that was resolved but in AWS I see this problem again.

### Expected Behavior

No drift in the EventBridge Rule

### Observed Behavior

EventBridge Rule drifted if it is using a DLQ

### Test Cases

Create a EventBridge Rule using Cloudformation with a target with a DLQ and check drift status of the stack

### Other Details

_No response_