Not an apex domain
The domain c-24-127-189-138.hsd1.mi.comcast.net is not the root of its zone.
Instead, try zone transfer on hsd1.mi.comcast.net .
Instead, try zone transfer on hsd1.mi.comcast.net .