The reason for your issues are sorting issues. Translucent materials don’t draw into the depth buffer for technical reasons so sorting triangles can be difficult. There are a few ways you can potentially fix it.
One is to check the box (I think in the mesh instance settings) to sort triangles. Another is to enable Order Independent Transparency in project settings, which adds to the cost of transparent materials but makes layered translucent materials look more correct.