If longevity is the objective, you can skip all kinds of weights.
Only bodyweight is enough for a toned & endurant body, and the risk of injury is the lowest.
It's quite simple. Any kind of serious Athletic activity (the most serious being Olympic training) puts more strain on the body.
It comes down to what your goals and what you are willing to sacrifice in terms of injuries are.
Personally, I know a bunch of guys/girls who do crossfit in Europe in a serious gym.
They do extremely intense exercises, lots of compound movements.
Yes they are beast athletes, but they also are injured all the time.
Meanwhile, I'm doing my basic prison/jail routine and I never get injured (pushups, dips, lots of stretching, etc).
Also if you want to add the ultimate sport for longevity and general health: swimming (in a pool).
With swimming you nearly never get injured and its extremely low impact on the body. At the same time you have resistance all over your body.
It's the most complete sport with lowest injury rate.