Dench's M was brilliant. But it's Judi Dench, she's going to be great whatever she does.
Moneypenny was on active service at the start of Skyfall, but by the end she was given a desk. She does actively help him.... from her desk. I mean whoopdeedoo for the men on letting her leave her desk once in a while, but as a progressive female character, she's still primarily a secretary. That's not progression. She started as an agent!
As for the Bond girls, Vesper Lynd was probably the best progressive depiction so far, but they're still referred to as 'Bond girls' and their primary role is to sleep with Bond, which happens every movie by the way. There has to be at least one sexual conquest. 🙄