Twin choreographers Megan and Jessica Kennedy explore the innermost fears of Cork people for their ambitious dance opera, writes Ellie O’Byrne