Despite Fabrizio's death and Elisa's presumed escape, the very end of A Classic Horror Story suggests that the mafia-sponsored operation is still up and running.
1. A Classic Horror Story. A classic horror story is a typical movie with a lot of jump scares and an unusual twist that turns all the tables and changes the plot of the film.
Azazel promises to resurrect John so Mary can have a normal life with him if she gives Azazel permission to enter her house in ten years. Though Dean tries to intervene with the Colt, Mary makes the deal and John is resurrected while Azazel flees Samuel's body before he can wake up with no memories of being dead.
Of course, that was after John's death, which occurred in the season two opener, In My Time of Dying when John sacrificed himself to save Dean. Needless to say, there's a lot Sam and Dean probably never got to say to their dad before he died.