There may come a point where some quarters of the public will willingly accept some governor, attorney general or president ignoring a supreme court ruling: then what will they do? As Andrew Jackson apocryphally noted, the supreme court has no enforcement arm.
This already happened with Joe Biden ignoring the Supreme Court on abolishing student debt.
The supreme court shouldn't rule on policy like you suggest, but on the law.
But I did not request any sources. A substantive argument is excellent its own right, even if citation-free.
"shall hold their Offices during good Behaviour" is probably what's meant to address political conflict with a specific person: They nominally can't be removed by the person who nominated them.