well yes real world tends to be black and white, you can either carry your panic buy shopping home or you cant. there are very few situation where only particial completion is a benefit
there are huge variation in the strength curve in doing say an ATG squat, you are considerably stronger above parallel than you are below, to the weight you can lift isnt stressing the muscles in the high range even more that people gain momentum in the lower part and power through the top half, so not only are you building stengh through a movement you will seldom if ever use, your neglecting to properly load the section of movement that will come in handy
so its worse than pointless, its counter productive
yes if you want the best transference of exercise to real world applicability you need to find movements that mimic real world issues, saying they help, but dont manage to complete the task is answering the question very clearly, they didnt help enough
if you want to be able to carry heavy things there is no exercise better than carrying heavy things for the duration you may need to carry them and squatting will have very little effect on your ability to do that and ATG squatting even less