Apex domains cannot have CNAME records.
Question and response
Question
dig sfnight.com. NS
Answer
sfnight.com. 5 NS ns-736.awsdns-28.net.
sfnight.com. 5 NS ns-784.awsdns-34.net.
sfnight.com. 5 NS ns-1797.awsdns-32.co.uk.
sfnight.com. 5 NS ns-485.awsdns-60.com.
Authority
The response has no authority records.
Additional
. 0 OPT ; payload 1232, xrcode 0, version 0, flags 0