> our brains just generally don't operate on a rational basis because it's not practical for humans.

It goes way deeper than that. Reasoning being hard to do well would explain a high error rate, but not systematic biases. I think human reason mainly evolved for (as you said) getting ahead socially, and only secondarily for solving object-level problems. There's a good recent book, The elephant in the brain.