Q: So, is there a need to tell Google to remove the URL? Or, if you unpublish the page will it just drop the URL?
Short A: You should update your sitemap in Google Search Console, so Google get’s notified immediately (instead of waiting for the next crawl).
Longer A: No long answer.
Hope that helps @PSM