I know this post is quite old, but I’ll leave it here for people on the internet that may stumble with this post.
I made this plugin, that tackles some of the current UE5 limitations when working with 2D. It works alonside the Tiled map editor (which has quite more features to work with tile maps and tile sets) and let’s you import those maps into UE5. And in addition it supports animated tiles out of the box and some extra stuff like custom properties and collisions.
You can check it out here: https://www.fab.com/listings/5906c3e1-6ca6-48b3-9694-57fbb0c08037