Updated the original post with new findings.
Cannot edit the subject anymore, but if someone can, I guess, this one should reflect the described issue better: [Grafana 8] [Unified Alerting] Single multi-dimensional alerting rule on multiple queries returning several time series