I think you are off base and misguided with this statement and this is where the "functional training" bullshit that gets tossed around starts messing shit up. The strength training that you do in the weight room should be there to build a solid, all around foundation of strength. I don't think anybody is deadlifting to be able to increase real life "picking up stuff strength".
Any athletic player will greatly benefit performance wise from deadlifting, but not because of being able to pick something heavy off the ground with two feet securely planted, etc. They will benefit because of increase strength of the gluteals and hamstrings as well as increase lumbar stabilizer strength, grip strength, etc. so when they are playing football they can do so with higher force/power, increased resilience, etc.
Not all of your training needs to be "sports specific". The only people who should have their weight training "sport specific" are olympic and power lifters. Other than that, all other athletes lift to build upon their overall strength and then perform their sport/activity (football, baseball, wrestling, etc) to increase their ability at that specific activity.
Yes,there are very few specific exercises that may translate better to your sport and an exercise's risk vs reward ratio will change depending on the sport of the athlete, but overall strength training should be there just to build a overall base of strength. Specificity should be left to that individual athletic activity.