Is there a standard term for the tension that arises from people depending on the existence of the things that they get paid to mitigate? I've heard people mention the potential conflict of interest where anyone who gets paid to do something would lose their livelihood if that thing stopped being necessary, so in a sense we all have reasons not to want to solve things too well or too completely.

That's not exactly what you're talking about in each case, but it could be relevant.