That is exactly what the framers wanted from the federal government. Your following sentence directly contradicts your entire point. We're talking about FEDERAL POWERS.
In any case, there's nothing contradictory in that statement. "Limited government" is a term with specific meaning in libertarian and neoclassical circles. It refers to a society in which the government, which may be democratically elected, has a limited range of powers and can only pursue certain ends. In such a society, the majority cannot vote to pursue a particular end if it is outside the proper scope of government.
The framers did not implement "limited government" in the U.S. They created a limited government, the federal government, but only against the backdrop of the un-limited state governments. In the U.S., the "government" (between the state governments and the federal government), can pursue nearly any end that voters might wish to pursue. It is, together, limited only in scope by certain Constitutional rights. The limited nature of the federal government is just a tool to divide power between the state and federal levels.