Hi Alex,
This is currently partially possible, though sadly I don't think entirely what you need is. Database does have support for running in Editor, and can work with standalone builds (I've confirmed this by building and running the Database testapp we provide for x86_64 mac), the problem is that Auth currently does not. We are aware that having full desktop support for all the Firebase Unity SDKs would be great, and as you pointed out, is on our roadmap.
As that page describes, there are currently two supported options for Database from Editor with regards to authentication. First, if the database is set to public access, then the lack of Auth is fine, but there are obvious concerns about data access then. Alternatively, you can use a service account (the instructions for setting that up are also on that page), the problem there is all your users would be using the same service account, which I wouldn't recommend.
Sorry there isn't a straightforward solution, but hopefully this helps.
-Anthony