"its scotland's oil" was about Maggie Thatcher, and how the revenue was spent. Now scotland has independent tax raising powers, the border with england for sea resources was carefully restruck to favour england (look on a map to the boundaries, they aren't what you might think)
Australia has soverign wealth funds. Just, not made with revenue from this kind of industry. This kind of industry dominates the political landscape and has impeded the uptake of solar and wind, and replacement of coal for power generation. I don't mean silently: this is a quite overt distortion, active, such that major corporates actually have withdrawn from the australian mining and minerals council because its like the NRA, single-issue distorting of the polity.
In the early 2000s an Australian labor government tried to raise a tax analogous to a petrol royalties and revenue tax, and was pretty much de-elected by sectional interests on the strength of industry opposition. (the PRRT exists. the MRRT was voted down)
Mining employs around 40,000 people in a nation of 25 million. Solar and Wind and Tourism would probably employ more people. But, the voting effects of mining establish a lock on our senate (and sometimes, lower house) which make it next to impossible to see change. The industry is running the government, at one remove.
I don't believe for a minute Norway is all peaches and cream, but it probably has a better sense of cohesion around its role in the world, and the benefits of the sovereign fund, and future money, and de-carbonising the economy. Norway was an extremely poor, -to the extent of massive nutritional death in winter-poor economy. It's moved the dial to a different place, and done it quite carefully, economically speaking. (Norwegian settlers in the USA and Canada came because of a potato famine)
We're envious. (well, the Australians who don't derive income directly from mining, oil or gas)