At its beginning, the description of Community-consensus-needed says "Local, on-wiki community consensus is needed to implement this task (e.g. a configuration variable or setting change)". This implies the tag is to be used for tasks where behaviour of MediaWiki is customised for one wiki or another, as the description asks for a "local consensus" (meaning the ticket impacts a single wiki) and the only two examples it gives are configuration variables and settings.
However, at the end of the description, it also says (in bold) that "[it] can be applied to any type of task, not just those requesting a configuration change". This feels contradictory to the above, as nothing in the rest of the description mentions anything similar to regular code changes.
In addition to that, it is impossible to have explicit and direct consensus for every single change made to MediaWiki. Requiring that would pretty much halt all development, as dozens and dozens of changes are deployed with every train, most of them have little impact on most end users. Instead, software development generally works by soliciting user feedback (to plans and to finished products), and incorporating that feedback to final result. In most cases, the final decision whether to deploy something on a wiki is a configuration change, which is then in scope of Community-consensus-needed. In other words: consensus is important for the deployment of a feature, not to how the feature looks like by itself.
To summarize, if this last sentence was kept on Community-consensus-needed, it would mean the tag would get applied to changes that someone contests. That feels contrary to the idea of Community-consensus-needed – to enforce a policy "this kind of task always needs community consensus" by saying "having this tag on means this consensus was not demonstrated yet". Keeping the sentence would mean the tag would be applied on ad hoc basis (whenever someone disputes anything), rather than based on a predictable process or a policy.
The final sentence was added by @Frostly in 2023. As far as I can see, this change was not discussed on a ticket (at least, I didn't find any under Project-Admins or Phabricator, where I would expect it). I only managed to find discussions in which we explicitly decided not to have a tag for "implementation change that is contested", such as T226671: Proposal for global tag: "Needs Discussion" or T76311: Add needs-consensus tag for "contested" tickets.
Hence, I propose to remove the last sentence from Community-consensus-needed and explicitly restrict the scope of Community-consensus-needed to configuration/setting changes only.