aws_lambda_event_sources: Amazon MQ (ActiveMQ / RabbitMQ) trigger support

### Describe the feature

AWS Lambda [supports Amazon MQ as a trigger](https://docs.aws.amazon.com/lambda/latest/dg/with-mq.html#services-mq-eventsourcemapping) (both ActiveMQ and RabbitMQ) for some time already, but it is not supported by CDK.

There is already an issue #23764, which was IMO closed by mistake, as Lambda support this trigger for some time already.

### Use Case

To eliminate the inconsistency and being able to use AWS managed RabbitMQ as a Lambda trigger

### Proposed Solution

_No response_

### Other Information

_No response_

### Acknowledgements

- [ ] I may be able to implement this feature request
- [ ] This feature might incur a breaking change

### CDK version used

2.74.0

### Environment details (OS name and version, etc.)

MacOS

Start by locating the aws_lambda_event_sources implementation and its existing Lambda event-source integrations, then compare their patterns with the AWS Lambda Amazon MQ trigger documentation. Done means CDK supports both ActiveMQ and RabbitMQ triggers with coverage for the supported configuration and corresponding tests.

Written by the indexing model from the issue text.