Regardless of the realities, what do the American people want? No poll that I have seen has suggested that a significant majority desire other than the status quo. They want Roe v Wade upheld but they don’t support the full rights of women to procure terminations that I would advocate. The American majority, however, is not what is now represented on the Supreme Court.
Roe v Wade puts abortion in the rights part of the constitution. If Roe is overturned then abortion becomes a matter for the legislature of each state. At which point the majority get to have their say, right? That being how democracy works?