Google Sites has a 5-second load limit for iframes. Reduce the data range in Looker Studio to "Last 24 hours" only. Do not load a 5-year history.
If you want, I can:
Even a perfect googlesitespolytrack setup hits snags. Here is how to fix them. googlesitespolytrack