Can a boat sink in the rain?

Yes, but most boats have drains in the open cockpit area (scuppers) to allow the rainwater to flow back outside to the sea or lake. Most boats that do sink, sink for some other reason than rain.