Powhatan Sampson Wren, CSA service