mbdix, I don't think anyone said to avoid training with heavy weights. More about the frequency and intensity, avoiding routines that are for people on PED's. Trying for PB's all the time or lifting for too long without cycling how much you lift will cause problems.
How old are you? I ask this because I most certainly had a different idea about heavy weights when I was in my teens and twenties, than I do today as a middle aged man with 25years of training under my belt. If you talk to anyone that has trained for a long time and is over 35, even if they are taking PED's they can't train with as much weight or use looser form as they did when they were younger, without injury.
OP asked about longevity and health, not about what it takes to become a pro bodybuilder, or powerlifting record holder. An extreme example is Ronnie Coleman who we all know and love, has lifted some incredibly heavy weights. He achieved joint record for # of Olympia wins, but his body has paid a heavy price, since retirement has had to undergo numerous surgeries for back and hip replacements, in his early fifties. I guess if you asked Ronnie if it was worth it, I bet he say it was, and probably wouldn't do anything drastically different if he had the chance over again.
Dorian Yates another massively successful Mr Olympia tore numerous tendons, brought a premature end to his career. In hindsight he admitted that he would have avoided going really heavy when he was in a depleted state during contest prep, if he could do it again.
Francis Benfatto a late 80's early 90's BBerwho is renowned for having one of the most aesthetically pleasing physiques of all time, started training with Kevin Levrone, who used very heavy weights, lower reps. End result torn pec tendon for Francis, which he didn't get surgically repaired, ended the perfection of his physique.
Tom Platz tore his biceps tendon same story again, never the same.
Lee Haney won as many Olympias as Ronnie, wasn't anywhere near as strong as Ronnie, but had an ethos of "Stimulate, don't annihilate". Never suffered any major injuries, and is in has late fifties or early 60's and says he doesn't have any joint problems unlike so many of his contemporaries.
When I was young magazine articles used to regale tales of pro bodybuilders training to the point where they wouldn't feel like they had a good leg workout unless they chundered, or couldn't walk.
My point is you don't really ever need to approach this intensity to increase your strength dramatically, or build lots of muscle, even if you are on PED's.
Note if your a competitive powerlifter, professional bodybuilder, etc this attitude might sound gay, if you really are talented and genuinely are at a high level, then yes you are going to do whatever you think you need to be the best. That's great but its not for the majority of guys that that want health and longevity as OP asked.