For instance, in Europe, the limit is on average somewhere between ten and twenty weeks (outside of obvious exceptions like the life of the mother or whatnot), and was overwhelmingly a result of laws passed by, you know... Legislators.
Democrats think this issue will help them in the midterms because a majority of Americans consider themselves pro-choice... But I think that's a misreading because it exaggerates and oversimplifies.
For instance, most people who are pro-choice are opposed to, say... elective abortions in the third trimester where there isn't a life of the mother kind of reason (as rare as that is). Most people who are pro-life aren't opposed to plan b or abortions performed for reasons of rape, incest, or life of the mother.
Hardcore believers in "no abortion ever for any reason" or "all abortions are fine literally any time prior to birth" are rare exceptions to the discourse. Just about everyone recognizes, wherever they land, that elective late term abortion isn't the same thing morally as early term abortion for reasons more substantial than "I just don't want to be a mom yet".
If Roe is indeed overturned and kicks the decision to the states, very little will change. Red states will have more restrictions than currently, while nothing will change in blue states. There will probably be a decrease in abortions in red states, but... You know... A short drive across state lines may be an unnecessary burden in the mind of the pro-choice side, but isn't the end of the world the way abortion is for the baby.
Certainly, most states won't outlaw abortion entirely, and that won't likely be a thing even in the reddest states. Legislatures will have a variety of stipulations, but absolute prohibition isn't something likely even somewhere like Texas.
For the most part, women who want abortions that aren't done for health concerns for the mother or baby will have to get them (locally, in red states) when the baby is less developed and make the decision earlier than they might have otherwise.
Hopefully an overturning of Roe will lower the temperature of the debate and lead to a recognition of nuance and variations in local cultures trying to balance competing interests between mothers and children in different ways.