Is this really true though? In the projects I've seen this Covenant pushed heavily, it just seems to be a way to distract from building the product, to instead spend valuable contributor time debating identity politics.

There's a time and place for this sort of thing (e.g. Twitter); open source projects are typically not an appropriate venue.