If I delete my RSP on STI ETF from DBS, does it mean that I am selling off my STI ETF?

Nope, rsp is just an order to purchase $x worth of that ETF every period. What you are doing is just stopping the order, your original no. of shares do not get affected unless you physically put the sell order.