If your government commits to a public spending program that directly requires your only revenue stream to be $x then it is no surprise when you run into problems when that revenue stream falls below $x.
Norway is a much more diversified economy but not only that, they have diversified their sovereign wealth fund, furthermore, the revenue from oil is not linked to their social spending program. They understood that if it was its fluctuating price could not be relied on. Also, the 'free money' would distort the domestic economy via rampant inflation to such a state that it would wipe out local industry.
Instead the money is invested in a wide range of companies, currency and properties around the globe with the majority of the profits reinvested in the fund.
They draw down a small percentage (4%) as a dividend to spend on the local economy but populist governments are not able to raid the pot to deliver big social programs like Venezuela has.