Exporting Cloudwatch log group To S3 is failing

I tried everything possible . No matter what I am doing I am still getting the same error

OK, I'll give you a sample that actually works for me. This sample configuration might give you some insights.

AWSTemplateFormatVersion: "2010-09-09"
Transform: AWS::Serverless-2016-10-31
Description: Export CloudWatch Logs to S3 Bucket

Resources:
  # S3
  S3Bucket:
    Type: AWS::S3::Bucket
    Properties:
      BucketEncryption:
        ServerSideEncryptionConfiguration:
          - BucketKeyEnabled: true
            ServerSideEncryptionByDefault:
              SSEAlgorithm: AES256

  S3BucketPolicy:
    Type: AWS::S3::BucketPolicy
    Properties:
      Bucket:
        Ref: S3Bucket
      PolicyDocument:
        Version: "2012-10-17"
        Statement:
          - Sid: S3BucketReadPermissions
            Effect: Allow
            Principal:
              Service:
                Fn::Sub: logs.${AWS::Region}.amazonaws.com
            Action:
              - s3:GetBucketAcl
            Resource:
              - Fn::GetAtt: S3Bucket.Arn
            Condition:
              StringEquals:
                aws:SourceAccount:
                  Ref: AWS::AccountId
              ArnLike:
                aws:SourceArn:
                  Fn::GetAtt: HelloWorldFunctionLogGroup.Arn
          - Sid: S3ObjectWritePermissions
            Effect: Allow
            Principal:
              Service:
                Fn::Sub: logs.${AWS::Region}.amazonaws.com
            Action:
              - s3:PutObject
            Resource:
              - Fn::Sub: ${S3Bucket.Arn}/*
            Condition:
              StringEquals:
                s3:x-amz-acl: bucket-owner-full-control
                aws:SourceAccount:
                  Ref: AWS::AccountId
              ArnLike:
                aws:SourceArn:
                  Fn::GetAtt: HelloWorldFunctionLogGroup.Arn

  # Lambda
  HelloWorldFunction:
    Type: AWS::Serverless::Function
    Properties:
      Description: HelloWorld function
      Handler: index.handler
      Runtime: nodejs18.x
      Architectures:
        - arm64
      InlineCode: |
        exports.handler = async event => {
          console.log(JSON.stringify(event, null, 2));
          return { "message": "Hello World!" };
        };

  HelloWorldFunctionLogGroup:
    Type: AWS::Logs::LogGroup
    Properties:
      LogGroupName:
        Fn::Sub: /aws/lambda/${HelloWorldFunction}

Assuming that you have administrator privileges and not restricted by your organization (e.g., SCP), here are the steps to reproduce my config:

1. Save the configuration above in YAML file.
2. Create a CloudFormation stack from the YAML file you saved.
3. Check the resources the CloudFormation stack has created. It should contain an S3 bucket, a Lambda Function, and a CloudWatch Log Group.
4. Go to the Lambda Console and invoke the new created Lambda function (e.g., stackname-HelloWorldFunction-xxxxyyyyzzzz).
5. Go to the CloudWatch Console and export Lambda execution logs from the new created CloudWatch Log Group (e.g., /aws/lambda/stackname-HelloWorldFunction-xxxxyyyyzzzz) to the new created S3 bucket (stackname-s3bucket-xxxxyyyyzzzz).
6. After successful test, review the configurations (e.g., bucket policy) and compare with your current configurations.
7. Empty the bucket and delete the CloudFormation stack.