If you are operating under the "sports team" analogy, you should fire them. If you are operating under the "we are a family" analogy, you should find reduced roles where they are useful. Different organizations choose different base analogies but it is easy to tell which one you are in.
This is very related, but not at all the same, as this essay I just published:
Team-oriented, outcome-oriented
https://blog.sbensu.com/posts/team-oriented-vs-outcome-orien...
Summary:
Some people are more motivated by caring for their teams, others are by achieving outcomes.