Websites are still super relevant, especially for more serious / professional usages, or in random circles like gaming (since PC gaming is a thing that refuses to die). Domains are still the primary way you get to control your web presence, and websites are still easier to spin up than apps while providing much more flexibility and control.

I do think it depends on what kind of sites you are building. If it's say a recipe website, sure people will just Google it and click on a link. But for websites with a specific purpose I think a easy-to-remember or at least a not-sketchy looking domain name still has some values. Some random examples: wikis (which actually have a .wiki TLD now), professional tools like Figma, a service that you want to sell, or let's say a social site like Discord, I feel that having a clean domain name still makes a difference. I don't know if anyone will ever be able to quantify it though.

E.g. I have been following gaming tournaments, and a lot of them are hosted on start.gg. I find that I can definitely remember it much easier than otherwise and I don't want to use an app for something like that, nor do I feel like bookmarking it.

(Note: To be fair though, start.gg is using a country-TLD and I personally have a distaste of abusing country TLDs like .gg/.io/.ly/.tv/etc but that's another story)