considering the very first sentence in the datsheet of SP3232 "True +3.0V to +5.5V RS-232 Transceivers" - i would say it wont
what you need is either of the following 3 options:
- RS232 transceiver capable of working with 1.8V logic
- logic level shifter 1.8V <-> 3.3V (or 5V) followed by a RS232 trasceiver like the sp3232 or max232 or similar
- logic level shifter 1.8V <-> 3.3V (or 5V) followed by a USB serial module (non RS232) e.g. FT232, CP2102..or similar.
for debugging it makes no sense to convert to RS232, the USB serial would be my choice (unless you're using an ancient computer without USB for debugging
)