Solar doesn't make sense because the sun doesn't always shine

Luckily, there are solutions for that

In most Provinces, net metering programs are in place so that homeowners get extra credit for producing more than they need when the sun is shining and can use that credit when they don't produce enough to cover their needs.

Residential battery solutions are also becoming increasing popular to store excess energy for a snowy day.

Source: 

More myths and barriers here.