Congress can modify or repeal treaties by subsequent legislative action, even if this amounts to a violation of the treaty under international law

So no, treaties do not affect US national sovereignty. Appeal to sovereignty is a charge you can not level at any treaty from inside the USA.