There really needs to be some return to commons where ownership of certain things is just discarded so that everyone has the opportunity for self-reliance and self-actualization without needing to provide something of value for others. Community gardens, city parks, and city pools are like the fuzzy, myopic, "My memory's not as good as it used to be" view of that commons fitting into the modern world. The problem is that kind of participation doesn't provide a verifiable exploitable value the way that working under someone towards a set goal does, and our modern economic systems BSOD at even the thought.
In short, it's okay to not be useful just so long as you have something you want to do. Intellectual stimulation will always be a core need, but working for sustenance doesn't have to be.
Well, it certainly won't be possible as long as we tie people's housing, food, and health care to their ability to convince others they are useful.
Society currently sends the message: "If you aren't useful, you don't deserve housing, food, and health care". I think the existential angst is something we have to address as we transition into that post-work economic system, but I don't think it's actually possible to address until we make that transition.