The new workbox service worker implementation uses
UrlHelper.absolute. Since this is a compiled asset, it stores the full URL, containing the full hostname of the primary host in a multisite environment.
I think it should be using
UrlHelper.local_cdn_url instead. This also circumvents the need to recompile assets after changing the hostname.