### Elasticsearch Version

8.0.0

### Installed Plugins

_No response_

### Java Version

_bundled_

### OS Version

n/a

### Problem Description

When creating a transform with a `retention_policy` configured, `delete` permissions are not validated against the destination index. Consequently, the transform may fail to run later once the retention policy attempts to run. 

It should be validated and fail on creation (if validations are not skipped), just like we do for our other permissions.

Additionally, the documentation needs to reflect this permission nuance as right now `delete` is not mentioned.

### Steps to Reproduce

 - create a transform with a retention policy with a user without delete permissions
 - notice its failure 

```
task encountered irrecoverable failure: org.elasticsearch.ElasticsearchSecurityException: action [indices:data/write/delete/byquery] is unauthorized for user [<username>] with roles [<roles>] on indices [<destination index>], this action is granted by the index privileges [delete,write,all]
```

Related issue: https://github.com/elastic/elasticsearch/pull/84941

### Logs (if relevant)

_No response_
x-pack/plugin/transform/src/main/java/org/elasticsearch/xpack/transform/action/TransformPrivilegeChecker.java
privRequest.applicationPrivileges(new RoleDescriptor.ApplicationResourcePrivileges[0]);
        privRequest.clusterPrivileges(Strings.EMPTY_ARRAY);
        privRequest.indexPrivileges(indicesPrivileges.toArray(RoleDescriptor.IndicesPrivileges[]::new));
        return privRequest;
    }
    private static void handlePrivilegesResponse(
        String operationName,
        String username,
        String transformId,
        HasPrivilegesResponse privilegesResponse,
        ActionListener<Void> listener
    ) {
        if (privilegesResponse.isCompleteMatch()) {
            listener.onResponse(null);
        } else {
            List<String> indices = privilegesResponse.getIndexPrivileges().stream().map(ResourcePrivileges::getResource).collect(toList());
            listener.onFailure(
                Exceptions.authorizationError(
                    "Cannot {} transform [{}] because user {} lacks all the required permissions for indices: {}",
                    operationName,
                    transformId,
                    username,
                    indices
                )
            );
        }
    }
    private TransformPrivilegeChecker() {}
}