My colleague is delightful, but bad at their job. Does that matter?

Does the fact my colleague undeniably makes our workplace a more enjoyable place to be make up for any inadequacies in their output?