Template Size Limit Increase

### Resource Name

Does not affect a specific resource

### Details

The current maximum template size is 1MB, requesting for this limit to be reviewed and increased by as much as possible because when using AWS CDK, the template size grows exponentially and results in this limit being reached even without reaching the maximum number of resources within a template.

The issue names no repository files, tests, or entry points; start by reviewing the CloudFormation template-size limit and the AWS CDK growth described here. Done would require a decided and implemented increase to the service limit, but the payload provides no local implementation or verification path.

Written by the indexing model from the issue text.