There are currently no plans to support CentOS Stream 9 for Cloud One - Endpoint and Workload Security and this is because CentOS Stream 9 is a collaboration release with the RHEL engineering team.
The main focus of support for version 9 will be on AlmaLinux, RockyLinux, and RedHat Enterprise Linux (RHEL).
Reference:
Cloud One Endpoint and Workload Security
https://cloudone.trendmicro.com/docs/workload-security/agent-compatibility/
Deep Security Agent
https://help.deepsecurity.trendmicro.com/20_0/on-premise/agent-compatibility.html