@Godfrin, James Hello and welcome to Microsoft Q&A.
I understand you want to automate email reports from Azure Monitor about Azure Synapse pipeline run status, and you already have a query which satisfies your data needs.
Synapse itself does not send emails, the pattern is to make calls to a service which does.
Monitor suggests these email automation options. The link includes a tutorial on using Azure Function template for Application Insight. I think you should be able to just substitute the query there with your own.
Let me know if this was helpful or not.