All the major nostr web apps could go down at the same time in a big attack, and locally installed apps could also stop working for most users at the same time, but at least users with special relays would probably always have their locally installed apps working.