The domain wpbuffalo.com resolves to 35.212.51.1xx. Your problem is not DNS resolution.
The URL https://wpbuffalo.com gives a security warning (SSL certificate mismatch error) because it’s using a certificate for gvam1279.siteground.biz. When I proceed past the warning screen, it eventually loads a default Siteground page.
So this is not a DNS or Cloudflare issue.
Please contact your hosting provider (Siteground) for help to:
Provision an SSL certificate for your domain wpbuffalo.com
Configure your hosting account for your domain to display your existing WordPress site, rather than their default page.
After this gets sorted and your site works correctly, consider enabling Cloudflare Proxy again so Cloudflare can protect and accelerate your site.