Ceramic tiles on top of chipboard with cork tiles on top is just not going to last, even without the rot. The floor will flex under the tiles and the tiles and grout will crack, even if you've used flexible adhesive and grout.
If you want to tile that floor the whole lot will need to come up and be replaced with a proper base.