chore: Updates Project CFN resource handler to accept Lambda Proxy ARN as input & use as Http transport in Atlas SDK client

[maastha]

Proposed changes

Jira ticket: CLOUDP-303001

Please include a summary of the fix/feature/change, including any relevant motivation and context.

Link to any related issue(s):

Type of change:

• [ ] Bug fix (non-breaking change which fixes an issue)
• [ ] New feature (non-breaking change which adds functionality)
• [ ] Breaking change (fix or feature that would cause existing functionality to not work as expected)
• [ ] This change requires a documentation update
• [ ] If changes include removal or addition of 3rd party GitHub actions, I updated our internal document. Reach out to the APIx Integration slack channel to get access to the internal document.

Manual QA performed:

• [ ] cfn invoke for each of CRUDL/cfn test
• [ ] Updated resource in example
• [ ] Published to AWS private registry
• [ ] Used the template in example to create and update a stack in AWS
• [ ] Deleted stack to ensure resources are deleted
• [ ] Created multiple resources in same stack
• [ ] Validated in Atlas UI
• [ ] Included screenshots

Required Checklist:

• [ ] I have signed the MongoDB CLA
• [ ] I have added tests that prove my fix is effective or that my feature works
• [ ] I have checked that this change does not generate any credentials and that they are NOT accidentally logged anywhere.
• [ ] I have added any necessary documentation (if appropriate)
• [ ] I have run make fmt and formatted my code
• [ ] For CFN Resources: I have released by changes in the private registry and proved by change works in Atlas

Further comments

[github-actions[bot]]

This PR has gone 30 days without any activity and meets the project’s definition of "stale". This will be auto-closed if there is no new activity over the next 30 days. If the issue is still relevant and active, you can simply comment with a "bump" to keep it open, or add the label "not_stale". Thanks for keeping our repository healthy!