With a new generation of producers in charge and the fate of the studio in their hands, can Pierce Brosnan defy expectations and revitalize the franchise?