Is THWN wire used for dry locations only?

No. Per the National Electrical Code, table 310.13, THWN is suitable for dry and wet locations with a maximum operating temperature of 75o C. THWN-2 wire is suitable for dry and wet locations up to 90o C.