Have any car owners experienced the collision warning system automatically turning off when driving in heavy rain? I've encountered this, and I have to turn it back on afterwards. Is this normal?

It should be normal.

If it's about your car and this issue occurs every time it rains, then it's likely caused by a problem with the vehicle's sensor. In this case, you can consider upgrading the sensor to address this issue.