To play devil's advocate, many successful developer focused companies have gone down this route successfully. Neon, Cloudflare, Firebase, Github and many more have all made free tiers work.
I suspect there's a special dynamic for developers. I'm usually more willing to try out new things on personal projects, but I also don't like paying for things on personal projects. At work I don't care how much things cost, but I'll definitely advocate for tools that worked well on personal projects.
This is how Firebase, Supabase and friends work.
Getting 100 people to sign up for a free service is still work, but significantly less.