I would like to add two more areas to your examples of transportation and agriculture, healthcare and construction work. Just like food, people always need a good doctor, nurse, and pharmacist to stay healthy. Many professions related to healthcare will be in demand for a long time, although their work style may change due to technology. Construction work, people are increasing day by day in the world, the demand for housing and people is increasing. So there is a long-term demand for construction and repair work. For example, houses, roads, bridges, factories, and various infrastructures have to be built and maintained, so there is also a long-term demand for construction and repair work.
Ultimately, times will change, technology will change, but the value of works built around basic human needs can endure in many cases.
These fields of work no doubt will always be required, however technology goes forward so fast, that to do same job, number of employees always decreases. I cant wait when AI will be addition to doctors and it will decrease patients lines. In the past there were need a good number of people to cultivate fields, now 1-2 persons with special machinery and technology has replaced many. Good example are pharmacists also. Many years ago, people of that profession were similar to doctors. You could name your diagnose or problems, and pharmacist will give you medicine. Now people look everything online, get medicine recipes online and pharmacists play roles of sellers only.