No, it is not normal, although. male or female, I think if you pass the stage when you no longer notice someone you find attractive, you have probably completely lost your libido, but constantly eyeing every woman he sees is something else entirely.
The big question is; is he like the dog constantly chasing sports cars, but wouldn't know what to do with one if he caught it, or is he incipiently unfaithful?. The last is a danger sign and needs to be given deep thought.
But, as others have said, it is not normal and is not acceptable. It is pathetic and far from some women loving it, I think most women are looking at you with pity because you have saddled yourself with such a pathetic apology of a man. The women are probably laughing at him and think him a pathetic old man.
Have you tried telling him that the women he eyes up are probably sniggering at him behind their hands and thinking what a sad and pathetic old man he is. I would suggest that that approach might work better, if he doesn't respond to you saying how much it upsets you. Undermine his confidence in what he is doing, comment on the condescending smiles and the curled lips as they pass him, say how old it makes him look etc etc.