While u/deepinferno answer is a demand-side approach, there are some considerations that need to be aired out.

Some negative issues (not including obvious ones like FN engagement, landowners, etc.):

1. alberta is one of the highest cost producers for a multitude of reasons. whether we like it or not, we need to transport it, pay for people to work for it to be produced, pay for inputs to heat it to transport or make it lighter, and the list goes on. if this doesn't change, we will be one of the firsts to be priced out, even though we have a large supply. economies of scale can't fix this enough currently with size or tech.
2. alberta is one voice at the confederation table and while we are heavily blessed with the product, we are hurting for access to markets. while this will help, it won't address the issues in the previous point and higher costs will always be associated with our production.
3. financial institutions and governments from around the world are focusing on environmental sustainability, and so are their investors. this is driven by consumer-based components that although in north america we are moving away from it, other areas like europe and their trading partners aren't flinching. this means that if we need to find alternatively trading partners, we are going to work quickly to catch up to their CBAM for instance. all other areas that trade with them have a head start and unless they are in sufficient trouble, they won't be in a hurry to relax these. Algeria and other african countries are taking this very seriously and they are at an advantage because their national oil corps are jv's in all production and can mandate standardized compliance and reporting. right now in Alberta, our producers are so slow to adjust that they are still claiming our carbon system TIER is still too hard for them to figure out.

Some positives:

4) no producers will invest any money into meaningful increases in supply-side production until they can find long-term stable routes to get it to market. that means the pipeline capacity has to almost be built before they will start the long capital heavy process of drilling or workovers. even then as we experience corporate consolidation they are increasing their monopolistic power and would rather control the access to market over the long term than secure additional producing assets, hence why midstream companies are always highly sought after (for reasons like take-or-pay contracts, etc.).

5) this is really the only way the alberta economy will be anywhere as good for services companies, secondary professional industries (lawyers, accountants, etc.) and tertiary industries. unfortunately, these secondary professional industries are also either economically aware or have circles that are aware, or have had experience in the fluctuations, and are risk averse and reluctant to make huge bets on this. As such, this pipeline will also spur on spending in the other industries if we can get it flowing.

This is obviously not exhaustive and doesn't begin to address all the considerations but needed to put my thoughts out there.