"Being needed" is a poor choice of source of existential happiness and contentment though. Sure, it's an easy and accessible one for the masses with some mental gymnastics around how you view your income generating activities (or by having kids). But it's still dependent on others, as you need them being at hand to impact. See all the needless depression arising from kids moving out, or when people retire and complain about not being needed instead of finding new activities to explore or grow in.

As for the fear of human labour not being needed at scale due to me as most others needing an income, I'm optimistic there for two reasons. First, large unfed masses tend to start revolutions, something both governments and the not-working are interested in avoiding. Second, large amounts of young idle people has tended to result in stupid destructive behaviour at scale. So I'm confident there will be created opportunities for paid work for mostly everyone, and the conditions won't be too poor as there would be no profit motive to push people too far. Rather, the people having both the resources, time, and energy to consume, would still be what props up the system (until we can agree on trying something better now that we have excellent tools for guaranteeing transparency and optimising allocation at scale in real time).