James Bond legend Pierce has revealed his true feelings about who should take over the iconic spy role as speculation continues to mount over who will play 007