Earlier quoted context omitted.
"Nobody wants to spend their life being dead weight." I disagree. There are plenty of people who would love to be dead weight just to float around in a company. The larger the team/company, the more chances of those people being around. They pretend to be always busy and doing something but don't actually get anything done. Seen it all for 18+ years. Having said that, there are plenty of people as well who would LOVE…
In particular, people who never really figured out how to do more than bare minimum technical work tend to fail upwards into primarily "collaborative" roles.
This is the downside of trying to make knowledge workers a commodity and replaceable — work gets coasting and my side projects get my real creativity.