Will Dropstitch overwrite an existing Shopify product if the handle already exists?

No. If a handle collision is detected, Dropstitch appends a short hash (e.g. -abcd) so nothing in your live catalogue is overwritten.