Piety is very good to have in provinces with high zeal. A Governor with no dread and only +1 piety has a negative effect on the province (more unhappynes). A governor with +5 piety adds happynes in the province.
High piety is only needed in high zeal provinces.