If I was picking a kayak for this purpose I would get a high load bearing boat that can hold about 600 lbs. Most recreational boats can handle far less. Although less comfortable to paddle for long periods the larger canoes and handle a lot of weight as well. Canoes can be covered to keep the spray and rain out of the boat. In shtf if I need a boat I’m taking what I find that is suitable, on or close to the water.