VNet service endpoints are mainly used because they provide security. Using virtual network service endpoints eliminates the public internet access to your Azure resources, and it will only be allowed for the virtual network with service endpoints enabled for it.

Also, reserved public IPs are not needed any more, and last but not least, the management of virtual network service endpoints is very simple and straightforward, so it does not have a high management overhead.