> Doesn't a DB9 connector include all the DB25 RS-232 handshaking lines

Handshaking yes, but not all potential RS232 signals, of which there are 11.

I work with RS232 frequently and even CTS/RTS is rare to use. Never personally seen anything use DTR, DCD, DSR, or RI though I know they did see historical use.