You think things have changed so much that abortion opposition isn't still the majority in even a single state? That's an extraordinary claim requiring extraordinary evidence.
This is basically an argument that religious people shouldn't get a vote, or their vote should count for less. That is deeply, deeply undemocratic, and such a position is far more antithetical to our constitution than any possible views on abortion itself.
Well, no. Strongly religious people tend to view government welfare negatively. They also tend to give more to private charities which help the poor. I'm not interested in getting into an argument about the merits of government welfare vs. private charity, but your support for one over the other doesn't make anyone anti-poor. But this isn't relevant to my argument in any case, it's off topic and there's nothing more to add that would be in any way productive.
A 2014 survey can be safely dismissed. Back then Roe vs Wade was in force, and it was easy to say “abortion should be illegal” when that opinion would change nothing.
If a similar survey were held now, where female respondents, their daughters, family and friends could be directly effected by the SC ruling, I believe the change in voting patterns will be significant.
But even if not, i think the national interest should trump that of states in certain areas. Take immigration, for example. Most states would vote for restriction or abolition. The national government should control this, along with defence and foreign affairs. Most posting here would include body autonomy in this list.
Of course, as an Australian I would like that list to be longer.