Americans' views of religion's role in society have grown more positive in recent years. But many feel their religious beliefs conflict with the mainstream.