The performer and musician’s new show at Aviva Studios, Manchester tackles big themes but lacks direction