I wonder what would happen to Darren Herman in the long run. My understanding is he was hired to help driving the ad business side of Tile.

No, they just mean they will no longer engage with the Tiles. Their contract with Yahoo is not impacted and has nothing to do with Tiles.