Won't Resolve to sites.google.com hosted on google

In your Cloudflare dashboard, make sure that your SSL mode is set to Full (Strict).

https://dash.cloudflare.com/?to=/:account/:zone/ssl-tl

Your Google site doesn’t know what to with your naked domain and is serrving a 404 response. You should probably just set it up as a redirect to the www version directly in Cloudflare. Thae a look ate example number one in the following guide.