I’ve found a solution how to rotate normals.
1 - You should switch OFF “Tangent Space Normal” in material settings.
2 - Get Normals World Space, Rotate Normals around 0,0,0 pivot.
3 - Plug the result to Normal input of your material node.
Basically, you should use World Space Normals. Tested in UE5.0.1.