PD: Man who shot wife in front of kids found dead after standoff