Not an apex domain
The domain _c964b3734525ae9109ef64e558fa1c3d.spf.dnssmarthost.net is not the root of its zone.
Instead, try zone transfer on spf.dnssmarthost.net .
Instead, try zone transfer on spf.dnssmarthost.net .