"If the province had collected taxes and royalties on par with Norway and built a gigantic "sovereign" state fund, what would the rest of Canada do? Leave it be?"

Yes.  Just like the rest of Canada, currently, doesn't touch a dime of the Government of Alberta's own-sourced revenues.

...But somehow, it's seen as 'hating Alberta' to keep pointing this out....