Yeah, it's basically just that one workout.
How useful is it in terms of longevity? Well, the workout is progressive, meaning that as you get stronger/better conditioned, the workout gets harder. You're using weights, so really the only limits on how difficult you could make the workout would be your genetic potential.
As for hitting different goals, the workout is designed to improve LAT, develop supreme levels of strength endurance, build mental toughness, greatly improve grip strength/endurance, and greatly improve work capacity. You will pretty much be trying to get through the workout (and each exercise in it) as fast as possible, which means doing the exercises quickly, so it will build some speed strength as well.