An Azure network security service that is used to protect Azure Virtual Network resources.
For your question:
This is definitely a good approach to secure your app service if it is exposed to public internet.
Public Internet Users –connects via the internet--> Application gateway (WAF) –secure and protect --> App Service –gets the data from--> Local OnPremise SQL Database.
Hope this answers!