Not an apex domain
The domain concelebrations-rafter.vpsrdns.web-hosting.com is not the root of its zone.
Instead, try zone transfer on vpsrdns.web-hosting.com .
Instead, try zone transfer on vpsrdns.web-hosting.com .