Australia like Britain, did not use Oil royalties to establish abiding sovereign funds to persist after the oil ran out. Instead, the royalty stream has been used to draw down debt, and to replace taxation as an income stream in the present, but oftentimes has led to wasted spend on vanity projects, or on build out of infrastructure purely for extractive industry (mining, oil, gas) which in turn is hoped to generate revenue, but alas, not until a very long time in the future. Displaced costs in forward income estimates, much as in the movie industry, mean some mines and oilwells basically never pay tax, but generate collossal revenue which disappears into company consolidated debt. Its a huge rort of the model. There are royalties, but they are 'subverted' out of the picture.
"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)