Overturning popular opinion by the supreme court

Should the Supreme Court be able to overturn popular opinion? Is that undemocratic? How often and why should the Supreme Court listen to the will of the people?