I never execute rival faction's prisoners, I prefer:

a) The ransom money.
b) To give the demoralised, disloyal rabble of good runners and cowards back to the enemy for them to support.

Occasionally I execute rebels to increase the dread of a general, though only if they are an opposing religion/culture and usually only if the province has rebelled several times already.