If you present me with a trolley problem in which the only way to destroy Hamas also kills a million children, I won't know what the right answer is. I suppose it would depend on what would happen to Israel if Hamas wasn't destroyed.
However, the moral calculus for nations is not the same as it is for individuals. The standard established the last time the Western world fought a war it took seriously does seem to be "as many as it takes" and I suspect that this would still be the standard if such a war happened again. (All those nuclear missiles we have ready aren't precise weapons...) In that context, demanding that Israel should show restraint that other countries haven't and wouldn't seems like hypocrisy.
If you trust the casualty numbers that the UN Is using, then they imply approximately 3.7 civilians killed for every combatant (with the assumptions that children make up half the population and that children are never combatants). I don't trust those numbers but I admit that if I did, I would think they didn't look good for Israel. I suppose we'll have a better idea of what the truth is years from now when historians reach a consensus, but until then I'm going to reluctantly trust Biden's judgement because the US government probably has secret information unavailable to the public. (Biden is biased by his need to be re-elected, but I don't get reports from the CIA so that's the best I can do.)
As for justification: Israel should make reasonable efforts to minimize civilian casualties while accomplishing its legitimate military objectives, but Israel should not sacrifice its ability to accomplish those objectives in order to protect civilians. In other words, Hamas doesn't get to hold Palestinian civilians as hostages against Israel. If they try, then they are to blame for the resulting civilian casualties. The alternative is simply unworkable in practice, because the ability of Hamas to put Palestinian civilians at risk is almost total.
People often bring this up without noting that such a ratio would not be unusual in urban warfare against a well-prepared enemy even when the attacking army is doing what it reasonably can to reduce civilian casualties. Compare it to Mariupol, an example of what happens of the attacking army is unconcerned about civilian casualties: 25/26 of Ukrainians killed were civilians according to Ukrainian estimates. (8/9 were civilians if we use the Ukrainian numbers for how many of their soldiers were killed but the more conservative Human Rights Watch numbers for civilian deaths.)
Before anyone gets too excited: some of their electrodes are no longer able to record a signal from the patient's brain. They're reprogramming their software to work with fewer electrodes. No one is being turned into a borg drone.
I know the feeling. I've been in the USA for decades, almost my entire life, but as soon as I say anything, everyone can immediately hear that I'm not American. People who ask me about it are well-meaning and curious. I still don't like it, but I try not to show it.
There's not going to be a moment when the world suddenly goes from having oil to having no oil. Some oil reserves are relatively cheap and easy to extract. Other, very large reserves are currently so difficult and expensive to extract that doing so isn't profitable. As the easy oil gradually runs out, the supply drops, the price rises, and sources of oil that were not profitable at the old price become profitable. This maintains the supply of oil and stabilizes the price.
Eventually oil will become so expensive that alternative technologies will be cheaper than it. This will happen with plenty of hard-to-reach oil left. So it's true that the amount of oil is in principle finite, but that limitation isn't really relevant.
Why is my brain like this? Why do I always do things the hard way?
"Oh, there's this thing you have to do that'll take fifteen minutes. "
"I'll do it tomorrow."
"Oh, there's this thing you've been putting off for a few days. The deadline for it is coming up."
"I'll do it right before it's due."
"Oh, there's this thing that's past due, but it might not be too late..."
"I can't handle this. I'm going to pretend it doesn't exist."
"Oh, the thing that would have taken 15 minutes is now a major disaster that'll take days to fix and cost a lot of money. Your life is falling apart as we speak."