But it is the only diet research that can actually generate knowledge.
The studies you cite are nice and all, but the first two are for studies that measured outcomes after 6-8 weeks. If you assume an average lifespan of 70 years, the longest study represented ~1/450th of a human lifespan. And, as you mention, they only measure what we think are valid indicators, not actual outcomes! And the third study may control for all of the things you mention, but it doesn't control for the other foods the study participants ate!
Really the only piece of information that you need to know regarding red meat is that public health messaging for the last 50 years has been that people should limit red meat intake. And it was successful. According to this[0], red meat consumption has decreased from 133lbs per person in 1965 to 107lbs per person in 2016. But it is during this exact same time period that the obesity epidemic came into existence. So, perhaps red meat is marginally bad for you, but it is almost certainly not cause of all of the various afflictions that we think are caused in some way by our diets.
[0]: https://www.nationalchickencouncil.org/about-the-industry/st...