> but I can’t relate to this feeling of giving up because some work won’t be used.

People are fulfilled by different things. Some people are far more interested in their working having a meaningful (to them) impact to the "outside" world than the specifics of the work.