"Let It Be," which opened last night at the St. James Theatre, is at its best when it drops the gimmicks and relies on the superior talents of its musician cast