You are absolutely right about the cost-benefit balance in the case of cancer and red meat (or really in the consumption of anything). That's why it's important for people to understand our evolutionary past, even if it might seem peripheral to the cancer link itself. If we go into subjects like this with a flawed mindset, we'll get flawed results. If it was more commonly understood that meat isn't just tasty, non-nutritious, artery clogging filler food that greedy humans only recently started doing because slaughtering animals is fun, jumping to conclusions about red meat and cancer wouldn't be nearly as popular.
In the world where food is abundant and chronic disease caused by overconsumption of calorie dense foods is extremely prevalent, it’s worth re-examining meat as a staple food. This is not touching on our polluted world and meat’s role as bioamplifier of toxins in our foood chain, along with a bunch of other good reasons to re-examine our relationship to meat as a society
Like, it's plausible that the red meat is causing these cancers. It's also plausible to have a different cause - e.g. if people's lifestyles lead to a correlation between consumption of red meat and smoking (for the sake of argument - I have no idea if there actually is one) then we would observe a link between lung cancer and the consumption of red meat without there being any causal relation.
It's also quite plausible that certain ways of preparing food is causing these cancers (e.g. nitrates in bacon, and known carcinogens from high temperature frying on pan or open flame), and we're seeing the effect because we're currently often preparing red meat in this way, but replacing the red meat with fish or vegetarian equivalent in the same fried dish would still have the same carcinogens, and thus the intervention would not get the expected results.
So, a correlation between certain cancers and the consumption of red meat is a good probable cause for an investigation of the causal relationships, but I'd be wary of using it to argue for major dietary changes - the last decades had far too many counterproductive dietary recommendations (e.g. regarding cholesterol) because of non-causal evidence leading into wrong assumptions.
And indeed, correlations aren't causation, but the claim is “The study said it had identified causal relationships between eating red meat and coronary heart disease, breast cancer and strokes, on top of links already established with diabetes and colon cancer” and the "serious errors" are that “the study had failed to take into account the nutritional benefits of red meat as a source of vitamins, iron and protein, that should be weighed against any risks”. I find that a misleading use of the word "error". Don't you?
How would that invalidate research showing, for example, a link between certain cancers and the consumption of red meat? That some behaviour produces a competitive advantage at one time does not mean it comes without risk, nor that newer behaviours aren't better in some or even all ways, nor that it would remain advantageous for all time.