You are reasoning about this well. Offering a self hosted solution is a solvable problem that can be profitable. The challenge might be that there are multiple different strategies the folks at Notion could follow, but choose not to. Each is solvable and each can bring more profit. And yet they need to decide what to do and what not to do. You should not chase every rabbit and solve every solvable problem.