I definitely understand that Cloudflare Workers are likely to be unsatisfying as a Lambda replacement for people who want to use a language like Python.
I think there is a decent reason why Cloudflare, at least initially, went the route that it did. V8 Isolates allow them to run code from many different people without many of the cold-start, memory, and performance issues of offering a more full environment. V8 Isolates allow them to be a lot more efficient than something like Lambda. It does come with the cost of being more limited for things like language support.
I think it's a pretty good bet. Lots of people are comfortable with JavaScript/TypeScript (even if you or I don't love it) and WebAssembly is likely to become a decently supported compilation target over the next 5 years from a lot more languages. Microsoft has done a lot for C#/.NET support of WebAssembly and it should be quite good with .NET 6 coming in 2 months. Python, Go, and many other languages have at least some support for WebAssembly and it seems like that will only get better over time.
I definitely understand it being a turn-off. If you haven't read their post introducing them, I'd read it: https://blog.cloudflare.com/cloud-computing-without-containe.... It doesn't solve your problem, but I think it's a good read on why they made that trade-off.
https://developers.cloudflare.com/workers/platform/languages