99.9% say they wouldn't take it. The usual reason is "I'd get bored".
Then I ask them if the think the majority of other people would get the pill. 99.9% think that other people would take the pill.
I suppose that people really hate their lives, don't dare say that not even to themselves, and they think other people have a much better life.
The day-to-day decision won't be "live forever" vs. "die of old age". It will be "get sick" vs. "not get sick" and no one will take the former.
One could conceivably escape from this by escaping to another universe - if that's possible - but that's just fantasy at this point. As far as we can tell, even if you can live basically forever you will eventually cease to exist, when the universe ceases to be an environment that's conducive to existence.
So it's physically impossible to live forever. A few hundred billion years is probably an upper bound. Not a shabby run, but not forever.
I'm happy to consider the entropy problem solved if it is solvable. I don't know how to assess the odds of that.
Most say No.
I then add that everyone else would have access to them too, so their friends and family would also be around. They think a bit more.
Some then say Yes, but some still say No.
I then say they'd go back to a 25 year old's body.
Then they pretty much all say Yes.
The war disappears as soon as you change the conversation. I'm from a secular country though, so I don't what the American Religious Right would say.