Hey @SamKeene,
It sounds like you are close to figuring this one out! To get the FBX you need, you can right click the animation, go to asset actions, then export it. That will give you an FBX that you can edit in your editor of choice, or as you mentioned simply apply a rotation to when reimporting.
I hope this works for you, and good luck!