I want to make pubky so good that no indiehacker can be bothered setting up a backend to validate an idea. 

They would tell early adoptors; Just sign in with your pubky and come with your own backend, and that wouldn't be too much to ask. Maybe even attractive to users who know that their data won't disappear if the developer got distracted by another side project.