How to handle transparency for complex object with multiple materials?

Transparency in unreal is a fake thing without priority sorting.

Essentially, split out your mesh so that the transparent material is its own thing.

Look into the old car sample stuff where the windows are done with one mesh that has 2 differently set transparency types to get it working right.