Not an apex domain
The domain pool-174-119-161-78.cpe.net.cable.rogers.com is not the root of its zone.
Instead, try zone transfer on cpe.net.cable.rogers.com .
Instead, try zone transfer on cpe.net.cable.rogers.com .