Apex domains cannot have CNAME records.
Question and response
Question
dig celticpiper.net. NS
Answer
celticpiper.net. 5 NS ns-431.awsdns-53.com.
celticpiper.net. 5 NS ns-798.awsdns-35.net.
celticpiper.net. 5 NS ns-587.awsdns-09.net.
celticpiper.net. 5 NS ns-981.awsdns-58.net.
Authority
The response has no authority records.
Additional
. 0 OPT ; payload 1232, xrcode 0, version 0, flags 0