Former James Bond star Pierce Brosnan has joined Helen Mirren's calls for the new 007 to be male, following Amazon's 770M takeover of the iconic franchise