I am making this project again from scratch because my hard drive died and lost the original project. Anyway, I have made a Tilemap that has animated tiles and I gave it a Composite Collider which uses Tilemap Collider 2D.
I have a Player and I gave it a Box Collider 2D. It is expected red tiles to be impassable, but in-game the player just passes over them. It has worked before.