Yes indeed. Let's think very far ahead on this.
I'm glad you brought up the agricultural revolution. The effect that ultimately occurred in agriculture, once we went from 99% of the population needing to make food to less than 1% of the population needing to make food, was that the supply of food went into an enormous abundance and the price for the average consumer dropped to the point that no today, even the very poor in America do not need to know how to cook because they can eat prepared foods (food with even more productivity added). Whereas the diet of the average American before the Industrial revolution consisted of food that they had to prepare for themselves from the ground all the way to their dinner plate, now they can afford to have others do much of the dirty work.
Just as the Industrial Revolution increased our ability to HAVE lots of food and food that was easy to consume, so with Industry 4.0 and the Robotic Revolution increase our ability to have every manufactured good that you can imagine. Once we remove human labor from the manufacturing of goods, the transportation and warehousing of goods and even from the gathering of raw materials necessary to manufacture goods, prices of EVERYTHING will plummet and there will be more abundance than anyone can dream of. Things will eventually get to the point where anyone will be able to scrape together a few good robots, some solar panels and their personal transport drones and go live on an otherwise uninhabited hill or even a hillside. The robots will build them a house and farm the land to feed their family. And then what do they need so much money for anyway? They'll be free to work on their painting or gardening or whatever they wish.
But in the meantime what will they do? Just as near the beginning of the Industrial Revolution people will have jobs that would seem unbelievable 20 years ago. The Middle Class will hire full time butlers to organize their personal social lives. There will be full time home decorators who constantly redecorate the flowers and paintings on the counters and walls of the 5-10% top earners. Not just the very wealthy but the Middle Class and even some Lower Class will have full time health coaches and they will be studying every subject and hobby they have any interest in ... since their job now only requires 15-25 solid hours of work per week.
Cities will not just have road workers and other city workers to keep their city functional. They will have gardeners and artists that freshen up the looks of sidewalks and neighborhoods to give them an English Garden style of perfection. There will be poets and writers literally making money from every kind of novel you can imagine. The amount of music, film and other creative media will explode like nothing you can imagine.
Just as the people who heard of the new jobs from the original Industrial Revolution were incredulous that no one could ever make a living doing something as useless and silly as serving food to other people, so the jobs of the next Industrial Revolution look extravagant and unbelievable. But we will do them for the same reason we've done everything that we do that goes beyond merely taking care of our basic survival needs -- it's interesting!
