What chiefly explains the majority position against intentional major sins by prophets?

Finality of Prophethood and the Protection of Prophets