CSP Trusted site setting is used to provide permission to Lightning Web Component for communicating with the external endpoint

In the case of Drag Drop Upload to Amazon S3 app, this permission allows LWC to communicate with Amazon S3. This connection is secured.