Pierce Brosnan opened up about the iconic role on The Jonathan Ross Show on Saturday evening