CSIRO agrees to work with a controversial deep-sea mining project in the Pacific while conservationists say Australia is on ‘wrong side of debate’