My opinion here is the same as RBG's; terrible decision that strangled the nascent pro-abortion legalization movement in its cradle and prevented the issue from being decisively won by the pro-choice side. Was also very poorly thought out.
That said, is having abortion be legal the better policy? Yes, of course. Should it be overturned 47 years later? No, not unless virtually all states adopt laws keeping abortion legal in its absence.
interesting metaphor for this issue
Roe v Wade gave the abortion legalization movement what it wanted far beyond what was possible legislatively. It helped galvanize the opposition to abortion, it's true, but the pro-lifers pre-Roe were already fighting back against abortion legalization efforts.
In 1971, twenty-five states considered abortion legalization bills. Every one of them failed to pass. In 1972, the pro-life movement went on the offensive and began campaigning for measures to rescind recently passed abortion legalization laws and tighten existing abortion restrictions. In the wake of the Central Park protest, the New York state legislature voted to repeal New York’s liberal abortion law and was thwarted only by Governor Rockefeller’s veto.
https://time.com/4154084/anti-abortion-pre-roe/