No. Article II of the AoC, expressly says that "Each state retains its sovereignty, freedom, and independence, and every power, jurisdiction, and right, which is not by this Confederation expressly delegated to the United States, in Congress assembled."
So they did not give up sovereignty, but on the contrary they expressly retained it.
Rather, they simply delegated powers, jurisdictions and rights to the United States.
And accordingly, the 1783 Treaty of Paris expressly recognized each state as free, sovereign and independent; not dependent states of a singular free, sovereign and independent state.
The Constitution doesn't say that, either.
On the contrary, each state unilaterally seceded from the AoC, in order to ratify the Constitution; and did so by its power as an independent state.
And what's more, it only required nine of them to form the new union of independent states, so clearly it couldn't have been "the people of the United States in the aggregate."
As Madison observed in Federalist No 39:
So each state ratified the Constitution by the act of its respective people; rather than its delegates, as under the AoC; or the people of all states in the aggregate, as Daniel Webster claimed in his 1830 "Contract Theory" before the US Senate.
This therefore established the people of each state, into the supreme power over their own particular independent state; and they their will was supreme over their state, however they chose to express it.
So while the Constitution does delegate more power to the federal government than before; sovereignty (i.e. supreme final authority) remains in the states themselves-- namely with the state's respective people.
So the states could unilaterally secede again, each by the will of its respective people.
Just like they did the first time in 1787-1789, to ratify the Constitution in the first place.