Not an apex domain
The domain mail.merlin.ns.myhostingspace.co.uk is not the root of its zone.
Instead, try zone transfer on merlin.ns.myhostingspace.co.uk .
Instead, try zone transfer on merlin.ns.myhostingspace.co.uk .