That might be better as a video texture TBH.
Here’s the tutorial for changing UVs on a material. https://playcanvas.com/project/405882/overview/tutorial-scrolling-textures
In your case, rather than scroll, you would want to set the UVs on the material to be at each frame.
Here’s an unofficial project to do ‘sprites’ with textures that uses private API: https://playcanvas.com/editor/scene/1305675