Host web and App web come into picture when we are developing and hosting the SharePoint Add-in. The Host web itself suggest that it is allowing to host anything within it. So the SharePoint site where the Add-in is basically installed is called as Host Web while the URL of the SharePoint add-in is called as App Web.