Even this long-delayed (for a shadow docket case) limited ruling (can't send troops for now but left door open for a rehearing after lower court is finished) is an exception for history's most compliant SCotUS (unprecedented 90% favoring admin).
What about the war powers act are you talking about? It just limits situations (or purports to) where the president can use the military without a declaration of war. Even if we were suddenly actually attacked (not just Venezuelan forces fighting back) it wouldn't give any path to "no more democracy".
The President can now tell "his" DOJ to indict someone in another country (like its leader), and use that to 'legally' justify an attack on said country to grab the person.
Ironically, the current administration thinks that American courts can hold any president accountable for crimes, except the American president.
Question is whether the Supreme Court will sell us out or not.