It’s great that Godot was in a good place when Unity had its (inevitable?) implosion. Having used both engines I think they are comparable enough that Godot was a perfect fit for small indie and casual devs to move over to without having to learn a completely new workflow. If Godot hadn’t been around I don’t know where everyone would’ve migrated to.
If you want something with a small footprint I would personally go for Rust, but anything that compiles to a static binary is going to be better than something that needs a dedicated runtime.
Python is what I use for small one-time scripts and utility stuff that doesn’t need to run long, but it may be worse than Java…