it’s just a weird thing about unioning. When unioning, the first part selected dictates what the union’s orientation is. In the image below, the green arrow represents the union’s front face based on what part you select first. Left is how I unioned mine, right is how I think yours was unioned and hence your rotation being off.
Also, if your issue is resolved please mark the post as solved.