It's not about living forever, it's about optimizing your time while you're alive.
At least with Ronnie you can make a good argument it was worth it. It's easy to say "bro, not worth it!" after you're 60 and the fun is over. But if you guaranteed 8x Olympia in exchange for his health issues to all 22 year old bodybuilders, a lot would take it and not out of stupidity. Personally I wouldn't. And of course 99.9% of pro bodybuilders don't get anything close to Ronnie's rewards.
The best longevity route seems to be stay as lean as possible and exercise hard at least several times per week in a joint-friendly way.
https://www.youtube.com/watch?v=mQHdn9guvow&t=4s