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…
It seems like the AAA publishers don’t know what to do with that type of mid-budget game that was the staple of the 2000s generation.
Spend a bit of money (not crazy much), make something fun with a bit of originality, and just put it out for sale. No complex monetisation strategy or pipeline to funnel people to subscriptions. We give you money, you give us game.