Should we rejoice over the death of reshaim?

There is an apparent contradiction in the sources as to whether or not we aught to rejoice at the destruction of evil people. Let’s sort it out.