> then won't Google simply improve on these regressions using their decades of cloud database expertise

The developer experience of trying to emualate firebase locally has always been horrible, going on fifteen years, so I would guess no, they won't because they don't care.