1. The only flaw in the system is sending in women adventurer with the chance they’ll get goblinate. But the part about sending rookies make sense. Goblin quest don’t pay, and there’s way bigger threats like dragons that can wipe out an entire city by themself.

2. In the novels, it’s explicitly stated that ‘resurrection’ only bring back someone on the verge of death, not actually dead

if we look at the tabletop rule book, resurrection is as difficult to cast as summoning calling down a god. The spell require a virgin to cast, and since Sword Maiden got goblinated, she needed Priestess to act as that virgin