The court as an institution has a responsibility to maintain some sort of consistency if it wants any legitimacy.
How can people make decisions about where and how to live if their fundamental rights are changing year to year (and most recently being taken away)?
You are also not aligned with the current public opinion. The court is at its lowest approval rating ever, and that is before overturning Roe. If the court cannot maintain it’s appearance of legitimacy then it essentially fails as an institution. The court could have chosen to move more slowly, with more restraint, but it didn’t.
And you can say "yeah but racists were the bad guys", but that's not how any of this works, regardless of what narratives we decide to apply to history after the fact. Did the court's lack of perceived legitimacy in Birmingham or Little Rock (among many other places that required less extreme enforcement) cause it to fail as an institution?
The court only fails as an institution when it's decisions are no longer enforced. Last I checked we haven't reached that point yet. And even if we do, worth remembering SCOTUS survived the last civil war intact.
Or the court can function perpetually against the public will?
SCOTUS leaned liberal (in the sense that liberal justices tend to believe in larger-scope interpretations of Constitution) for a long time, now for the first time in a while they're leaning conservative (the Constitution says what it says and if we want it to say something different Congress should pass an amendment).
Honestly I find myself falling into the more Conservative camp from a judicial perspective. I'm all for gay marriage and a woman's right to choose, but I feel like we used SCOTUS to do an end-run around Congress to get both at a federal level, and from my layperson's reading the constitutional justifications for both feel stretched to me. In the same sense that you can use creative interpretations of the Bible to justify basically anything, you can do similar things with the Constitution. That isn't how the system is supposed to work