Getting insurance can cover the phone getting lose or stolen, too, which in my opinion could be a bigger threat than dropping it when you have all that protection.
I may be wrong, but I am pretty sure that Google's insurance doesn't cover loss or theft. There may be some other 3rd-party insurers that do cover loss or theft, like Squaretrade, but I am not positive.
If you get Google's insurance and break the phone, you've already spent an additional $179 to fix it, since the insurance is $99.99 and $79 for the deductible. Now, if you are unfortunate and damage your phone in the first 6 months, it's a lot cheaper to pay $179 than $700-900 to replace the phone. However, I am sure these phones will depreciate, as all phones do, and I wouldn't be surprised if these may only be worth $350-$500 in a year.
In my case, I currently have a Nexus 6P and a Nexus 6, so I look at those as a form of insurance. Yes, I would be upset if something happened to my new Pixel, but I would still be able to use a very capable device as a replacement.
If I didn't have the luxury of having a couple spare phones, I may be more apt to get insurance. However, if I did, it would be a policy that covers loss and theft.