That's not true, only 26% of Americans support abortion in almost all cases. Most support some sort of restriction. This ruling forces the States to determine what those restrictions are.
This is an extremely complicated and nuanced cultural issue. The debate that's happening now is one that was cut short by Roe—one that the rest of the West has had. Few other countries allow abortion with "no restrictions". States should be allowed to decide, individually, where they want to draw the line.
I'll add that this is in no way an endorsement of an anti-choice position. But there's no way to view this as "a minority enforcing social views on the majority."
The primary civic problem in this country is the neutering of our State and Federal legislatures. The Courts should not be legislating. The Executive should not be legislating. Force our Representatives to do their damn jobs.