It looks like this is still a problem as of UE5.5. My solution to this was developing a plugin that does this really well: allowing for tiles in a Tilemap to be converted to their animated equivalent, whether that be flipbooks or entire BP/C++ actors, with very quick and minimal setup - all while staying within and improving Unreal’s toolset.
Have a look: AnimatedTiles2D