Singer Brandi Carlile turned to a hypnotist to overcome her fear of fully submerging her face under water to avoid letting down her new music video director Courteney Cox