(I'm oversimplifying a little. There are 6 accredited programs, but there are 10 undergrad universities that produce psych majors, so the numbers probably look worse overall.)
You're right that the goal is to become a qualified psychologist, but the training pipeline doesn't match that goal. Crudely, there are training spots for less than 1% of psych undergrads (maybe 2% if you include research psychologists). There are alternative programs for counseling, but it's not the same license. The cost of these counseling programs is also astronomical for Canada. I know people who went that route and have $150k loans to pay back. If you're competitive enough to get into one of the clinical programs, they are funded (with students given stipends ranging from $30-$40k/year), but even if they aren't tuition is under $7k/year.
I would figure that the whole point of getting a psychology degree (as opposed to taking some psychology courses as part of your main degree) is to work as a psychologist? Why are all these people failing to get their psychologist qualifications?
Where I live, I've never met or heard of anyone who went for a psychology degree without the intention of becoming a psychologist. Sure, not everybody makes it to the end, and few end up doing research instead, but the whole goal of the degree is to produce qualified psychologists.