I am wondering if a sump pump installed in a damp basement should be
connected to a GFCI, or if this may cause the circuit to fail when it is
needed most, in bad flooding.

Does the NEC or other code dictate how to deal with this? Does it make
sense?