Pierce Brosnan, l'agente 007 in "missione" in Costa Smeralda