Clutch.ca warranty, is it worth it in this situation?

I have to buy car for a temporary job 300km from where I live and I need a SUV.

My biggest fear when buying a car is after like 3-6 months a water pump dies and it snowballs to a bigger and expensive issue. This happened before and I'm afraid of this since there are issues that you can't catch with an inspection.

So, I was planning to bit the bullet and buy the more expensive warranty to at least cover my ass with a catastrophic issue happens.

This is my first car in Canada so I'm not well versed on the rules and laws here. What does the extended warranty cover? I know that in 6 months and will probably need to replace the brakes and something here and there, but am I safe with a big headache like water pump, head gasket, radiator etc etc?

Thanks