As someone posted elsewhere in the thread, I hope Apple restricts requests to sites you've added as an "app" already. And I hope they find a way to keep sites from being able to tell you've "installed" them, so actually-useful sites or ones that I have no choice but to use (work, kids' school stuff) can't refuse to operate until I do that (I dunno, maybe they already do, I never "install" sites)
Personally, I don't use the native Twitter app anymore. I use the web version of Twitter, installed as an app, complete with shortcuts in my launchers. I have web notifications turned on and the experience is nearly identical to the native app. But there are little details that I think make it a better experience, like haptic feedback on mobile when clicking the Like button, or being able to select subsections of text on the screen. I have this on my Android phone, my Linux laptop, my Windows desktop, and my Mac Mini. It's exactly the same interface, everywhere, whereas the native app is ever so slightly different from the web app.
I have a lot of sites that I've installed as apps on my computers and it's great: SoundCloud, LiChess, HBO Max, NetFlix, Azure Portal, TeamWork, a couple of different WebGL games, my own management interface for my app at work. It's all basically just a shortcut to the site, without the URL bar chrome. I like it a lot more than using tabs.