Hi Mate, yeah it's a 6 pin 0.1" pitch DIL un-boxed male. This is cleaverly designed to save space and allow reverse connection.Which I have done before without damage. Just for the record, I have a bootloader for Mega8 that is very small, if you wanted to get all posh we could implement serial firmware updates.
Adding a serial port is trivial but does require an MCU with a UART AND available TxD/RxD pins. So this would require a Mega8 for example.
It might even be worth considering the use of an FTDI chip and going straight to USB. The OpenSource Arduino project recently released the Uno, featuring the ATmega328 MCU and a dedicated Mega8 in place of the FTDI chip. The benefit is this solution supports host AND guest USB connections. While this is of little use to us, we could use the opensource code for the USB implementation as this will be cheaper than the FTDI route.
Of course, if everyone is happy with RS232, then this is the simplest options with minimal code overhead. My preference would be to use the MAX3311 (1xTx, 1xRx) however I dont think these are available in DIP. Just provide a boxed 10-pin DIL 0.1" header for connection to D9 via a ribbon cable if required.
I really think the best course of action is to proceed with the current design and add serial and other features in future releases, maybe once you step to SMD.