The current position is moving away from google managed domains will add a layer of unnecessary complexity. While this sounds like added complexity since it is a separate service, in practice, it isn't any more complex?
We are moving from SaaS vendors to our own static hosting, and Cloudflare pages was the right choice. We will eventually be moving other Github pages sites as well.
My thought process is it is just time to make a change and might as well start managing our DNS in Cloudflare, leveraging the benefits where possible or cost-effective.