For reference, I looked at the blue book value of a 2003 top of the line Honda Odyssey with 100k miles. The current private sale value of this vehicle is $3,600.
The way both collision and comprehensive coverage works, you are paid the cost of damages, up to the actual cash value of your car. The upper end of the amount you can recover for your claim on this vehicle would be in the $3,500 - $4,000 range. Did your airbag deploy? If so, your car is totaled and you get a check for $3,600 (minus the deductible) because the repair cost is going to be greater than the ACV.
If you have collision and comprehensive coverage, I'm guessing you also had a $500 deductible. The maximum recovery under the policy is just over $3,000, and that amount drops as the ACV of the vehicle drops. You are paying $33 a month ($396) a year for this coverage. So if you net the deductible and the cost of the coverage, your max recovery is about $2,700. If you can swing the $2,700, it is probably worthwhile to drop the coverage. Consider it increasing your deductible from $500 to $4000.
For clarification, the no-fault aspect of your coverage is going to be on your PIP (Personal Injury Protection) coverage only, and isn't typically impacted by the presence of collision or comp. You will still need to maintain Bodily Injury, Property Damage and PIP coverage on your older vehicle.