its a solid framework for real time db and hosting but imo its struggling to keep up with competitors (aws, cloudflare, pocketbase, and my current fav supabase)
My bet is that google is shifting money and engineering time towards AI hype as opposed to firebase cloud infrastructure. Also they bought out firebase way back and googlefied it, then i guess you're seeing the final result
tldr: check out supabase