I think the flexibility and agility in domain modeling is the magic sauce of ORMs like Django. The Model definition directly drives migrations and form generation (incl Admin GUI).
If you know exactly the product you are making and don't need to iterate much on the domain model, frontend-oriented frameworks like Supabase and FastAPI make sense.
Supabase was neat to get started with. The moment you need any complex backend logic it all falls apart.
A lot of things, like CRUD editing in admin, is just done for you in Django.
My other issue with Supabase is just how difficult hosting actually is. Requires a whole lot of magic/weird undocumented trickery. Vs Django which just works.
It probably really depends on what you need to build though.
If you know exactly the product you are making and don't need to iterate much on the domain model, frontend-oriented frameworks like Supabase and FastAPI make sense.