@Alexander Grindberg Welcome to Microsoft Q & A Community Forum. I understand that the log query alert you have created isn't showing results when you receive alert mail. From the information you have provided, I assume you have enabled customer-managed storage account for the log analytics i.e, you are storing your collected logs in the storage account you have created.
Also, you have encrypted your storage account data with Customer Managed Key(CMK). To disable query redaction you would need to disable CMK via linked storage.
For more information on customer-managed storage accounts and CMK, refer this document.