Overall the Social Security Act does disallow prefunding of the fund with marketable investments but one of the reasons it hasn't been changed it's because it's actually a pretty solid policy, and the world for the most part also doesn't want the US to drop a 3 trillion dollars investment pinata on the global markets.
Overall while there is a lot of clickbait that inflates the Norwegian one it is not a special case if you look at public fund rankings http://www.swfinstitute.org/fund-rankings/ you'll see that the US Federal Pensions Fund and the California Reteirment Fund combined are about equal to the Norwegian National Fund, and those are just 2 funds.
Overall pretty much every state in the US has multiple SWFs, public funds or similar investment ventures those are usually directed at a specific funding target e.g. retirement, public schools, universities, infrastructure etc. Each fund funds usually only a single thing and each fund has a different source of revenue and investment goals and regulations, for the most part based on how the US federal system works in general it's a better model. California isn't expected to fund education in Texas or pay for a new road in Wyoming and vise versa so each state runs their own funds to fund their own needs (there is some federal money involved) overall it's likely a slightly safer bet than putting all your eggs in a single basket.
This is also why you simply can't blow up the Norway's fund to US levels and say you'll need 56 trillion dollars because the US doesn't pay for everything from a single fund.
The Gross National Wealth of Norway including the fund is about 85% of the US one when adjusted per capita, Norway is rich, the fund is wonderful and very well performing but it's not some unheard of economic miracle that no one else is using ;)