Okay, I was wrong. It's not at all likely that Dumbledore had the prophecy and Lily's death in mind when he turned Lily against Snape. He hadn't yet become willing to make that sort of tradeoff when the two of them were in school. And it beggared belief in any case that he could have correctly predicted the effects of his actions on Snape so many years in advance. So, no. Whatever his intentions were back then, if he's responsible for the prophecy, he merely capitalized on the outcome.

Despite that, I think it's now a little more probable that Dumbledore deliberately sacrificed the Potters, hoping to defeat Voldemort with Lily's sacrificial protection.

"After the day I condemned my brother to his death, I began to weigh those who followed me, balancing them one against another, asking who I would risk, and who I would sacrifice, to what end."

It also looks significant that Harry twice enumerated Lily's options as: leave, or stay and cast a curse. Voldemort offered her a third choice.

"Very well," said the voice of death, now sounding coldly amused, "I accept the bargain. Yourself to die, and the child to live. Now drop your wand so that I can murder you."

We know from canon that if she'd accepted, it would have saved her son. But Voldemort told her it wouldn't, and laughed at her for considering it. So she refused his offer and tried to kill him. Does that affect whether the protection is activated? Is it relevant that she had to willingly give her life out of love, when she died casting a curse that's powered by hate? Dumbledore didn't hear about this part. I'd love to know what he'd say.