All natural stone tiles have some degree of porosity and Limestone tiles are no exception, so no they are not completely waterproof. In a shower area and wet rooms additional tanking will be need, but this is no different to any other tile types, all walls will need tanking if in constant contact with water.