Having a job offer in Quebec doesn't have any impact on Advanced intermediate french requirement.
A lot of highly skilled people get temp work permits in quebec and still ultimately apply for Federal PR programs, meaning they intend to leave QC.
Acquiring that proficiency in french is no joke. And it is not just about getting PR, it impacts the rest of your life here. Education that kids gain (their English will be pathetic unless they end up going to McGill at some point latter in time).
And yes time frames are insanely long and unpredictable.
Lastly, if it matters to some one, the cost of CSQ is in addition to the fee you would pay for Federal programs. For a couple it would be close to 1K CAD.