Animating without a DCC

I’ve been exploring animating directly in Unreal through the sequencer. And so far most things make sense and can get pretty far. However, I can not figure out how change pivot point to object coordinates. For example I rotate an object 90 degrees, I want the pivot point to update to the newly assigned rotation. No matter what I’ve tried, rotating a pivot point or object will always stay as world coordinates.

All the research I’ve found about this is to go back to the DCC to change the pivot, or to just animated in the DCC and bring the animation over to Unreal. And I missing something basic, or is this still the case?