I had the same problem, and found the answer here: http://shadowpeakstudios.com/2018/10/22/unity-tutorial-animated-tiles/
Basically for it to work you have to download the 2d-extras from here: https://github.com/Unity-Technologies/2d-extras
Steps:
- Download the 2d-extras
- Extract the zip, then drag the "2d-extras-master" folder into your "Assets" folder in Unity
- Create a new tilemap: Right-Click in Hierarchy > 2D-Object > Tilemap
- Then right click on your "Assets" folder: Create > Tiles > Animated Tile (will finally show up)
