Yes, comprehensive motor insurance covers damage to your vehicle. If you have third party fire and theft, this does not cover damage as a result of storms or floods. If your vehicle is damaged by someone else or their property (such as a falling roof tile) to be able to claim against them you would need to show that they were legally liable (negligent).