The effect you’re seeing is known as the Moire effect similar to this:
This is a aliasing artifact that can sometimes be improved by using anti-aliasing like FXAA or Temporal AA.
The best solution in situations like this is to use a lower LOD or use normal maps to display higher detail rather than some modeled detail.
If you need any examples I can try and setup some as I’ve seen this question come up a few times. Feel free to post any images or video and I can offer some feedback that will help in some instances to reduce this effect.