What Flekz said is still correct as of UE5.5. My solution to this problem 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