For the color being purple and not red, it is how UE treat the texture.
It seems it adds some color add the very beginning if texture “x tiling method” and “y tilling method” are “wrap”, you can remove that if you put the tiling method as “clamp”.
Then you should get animation that goes to red color, like you shared with us.