Google has always encouraged us to let deleted pages return a 404 status..... don't obsess over them, they are natural, it’s a sign of a healthy, normal site, they'll disappear from the idex in good time once Google is certain the 404 status is genuine… etc etc. In short, trust Google to know what they are doing. Fair enough… happy to do that.
But I am more than a little curious when using the site: command to check the indexing of a site, and Google says it is still indexing pages that went 404 years ago, in some cases more than 15 years ago… So what happened to the advice that 404’s drop from the index in good time?
On the same subject, same site…. why does the GSC sitemap report show that as many as 40% of the entries in the sitemap.xml are not being indexed?
Am I missing something?