So assume a worker that perfectly knows and likes their job, but doesn't care about the process "above" him. If you enjoy the process of tiling and you have some experience with tiling, you don't have to care about what kind of building/room you are working on. Somebody designed the room, somebody picked the right materials, somebody probably bought them and it's in the spec/design. You can just "tile away" and make a career out of it.
Similarly in software, if you care only about programming and languages and whatnot and not the product - it's all you need with the right team/org. You won't be a product owner and you wont advance to "decision-making" levels in the company, but if you don't want to why would you need to.