> No I don't want to receive push notification from your site...
A PWA does not equal push notifications. Those are completely optional and should of course only be added where that makes sense. And even then, you'd have to agree to receiving them first.
> ...or ability to visit your website offline
Fine, you don't have to. In that case, the service worker just improves page speed and reduces data usage.
browser already do caching well, but you have to setup your server to sent correct headers and it's kind of difficult (unpractical) to set different caching policy for different kind of files if you're hosting many different sites, or you're on shared hosting. With service worker you can have more granular control over caching. But again, you really have to know, what are you doing. For regular website using service worker to improve caching is IMO overkill and also there is small chance, you'll make it unwillingly worse.
> it's kind of difficult (unpractical) to set different caching policy for different kind of files if you're hosting many different sites, or you're on shared hosting
No it's not. In Apache and Nginx (and I assume any other half decent web server) it is very easy to specify different cache times for each file extension. Same on shared hosting (.htaccess)
apache yes, but what about nginx? And there are many other ways, how to host your site (Amazon S3,...).
Also by unpractical I mean you have to have access to the server (ssh...). IMO it should be more concern of an app then server. But I'm not advocate for service worker for static resource caching (for websites).
Those were just examples. PWA is short for progressive web application. And this article title is "Turning your website into PWA". My point is, that if your site is just regular website not an application, staying conservative about implementing features is better, then implementing them recklessly, just for temporary page rank boost, or to show how cool programmer your are.
I would argue that, while not every site should have to be converted to a PWA to work properly, every site can benefit from it. If a website is not a complex SPA, why should it not be fast, secure or offline-accessible?
HTTPS or Service Worker caching is not something a mobile browser can do for you by default.
It seems to me that a lot of the technology making up PWA has been bundled with a PWA philosophy that has made it difficult for folks coming from a progressive enhancement background to understand how it can be applied. Too many people make it seem like an all-or-nothing deal, or couple learning these technologies with other technology that's not an essential. In reality you can incrementally add pieces to your approach for new site, or improve an old site.