Maybe. If that is all you can do, then sure, there will probably be some bleed over into real life.

But remember SAID - Specific Adaptation to Imposed Demands. Long term, horror games will not do a whole lot to really alleviate other fears in your life that are holding you back. In order to overcome those fears, you must face those fears.