You can put a domain in front of a notion workspace. You can either pay something like https://super.so (I've used them) or a few others, also there's a way to front it with your own proxy and maybe a cloudflare method but I forget. I set it up a year ago for my go wiki but I can't even remember the url to show you right now..

It works very well but IIRC there are some quirks but nothing that was game ending. It's still notion and not a website in the end.