This has got to be a problem with SuperTiled2Unity, not with Tiled itself
Yeah, actually animated tiles are supported by SuperTiled2Unity and the problem was eventually resolved on the Discord server: https://discord.com/channels/524610627545595904/524610627545595906/8112055307689...