How does this work with serverless (for example with DLT pipelines) which runs in standard access mode:

Serverless compute is based on Databricks standard access mode compute architecture (formerly called shared access mode).

To my understanding, from a logical perspective, this mode means that compute is shared with the workspace; as such, it should be possible to attach a managed identity to it.

But testing confirms that the IMDS endpoint is unavailable here as well.