Those in favour of reform should vote yes
In the 1930s the Seanad was abolished only for it to be re-created two years later. If it happened once, it can happen again.
In the event the referendum is approved, there is nothing stopping a future government asking the people to re-establish a reformed Seanad.