Why is CNAME file needed in github pages repository even I have the CNAME record at DNS provider?

I'm confused why CNAME file is also needed in my github pages repository? Why CNAME needs to be done twice at my domain provider and github pages?

How the things works together?