Despite admiring Bond star Pierce Brosnan, actor says the films disregarded women