Though he helped fight the demons, he was skeptical of the commands that the angels were supposedly giving the townspeople. He was outraged when the drinking was banned in the town - allegedly under the orders of the angels - which put him out of business. Later on, his fellow militia members tried to kick him out of town for being a "non-believer". When he refused to leave, Jane shot him dead.
Dean witnessed Paul's murder and told Sam and Castiel about what happened. Castiel stated that Paul's death was only the beginning of the Whore of Babylon's plan to condemn the town to Hell.