CNBC & AP surveyed 1,003 Americans about Facebook and found 46% think it will fade away.