Transient weak gravity in scalar-tensor theories