fix: Add depends_on policy and policy attachments for pipes

[magreenbaum]

Description

Pipes requires permissions for source and target actions to be attached prior to creation otherwise the following error occurs (example of one from examples/with-pipes):

╷
│ Error: waiting for creation AWS EventBridge Pipes Pipe (sqs-source-lambda-target-pipe): unexpected state 'CREATE_FAILED', wanted target 'RUNNING, STOPPED'. last error: Input parameter is invalid from the request due to : The provided customer role does not have permissions to call ReceiveMessage on SQS
│ 
│   with module.eventbridge.aws_pipes_pipe.this["sqs_source_lambda_target"],
│   on ../../main.tf line 611, in resource "aws_pipes_pipe" "this":
│  611: resource "aws_pipes_pipe" "this" {
│ 
╵

Motivation and Context

Permissions are required to be attached to the pipes role prior to creation otherwise error occurs.

Breaking Changes

No.

How Has This Been Tested?

• I have updated at least one of the examples/* to demonstrate and validate my change(s)
• I have tested and validated these changes using one or more of the provided examples/* projects

• I have executed pre-commit run -a on my pull request

[antonbabenko]

This PR is included in version 3.9.1 🎉

[github-actions]

I'm going to lock this pull request because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues. If you have found a problem that seems related to this change, please open a new issue and complete the issue template so we can capture all the details necessary to investigate further.