How to control how transparent a Diffuse BSDF is when using EEVEE's Blend Mode?
You can keep the alpha blend setting on the red material. You just need to add a mix shader and a transparent shader set to pure white :



The factor of the mix shader drives how much the red blends with the blue.