Apex domains cannot have CNAME records.
Question and response
Question
dig spf.hornetdmarc.com. NS
Answer
spf.hornetdmarc.com. 5 NS frank.ns.cloudflare.com.
spf.hornetdmarc.com. 5 NS cass.ns.cloudflare.com.
Authority
The response has no authority records.
Additional
. 0 OPT ; payload 1232, xrcode 0, version 0, flags 0