Are terracotta tiles slippery?

No. Unglazed terracotta tiles, which have been properly finished at the point of installation, will have a sufficient coefficient of friction for typical flooring applications. As with most flooring, standing water or liquids should be cleaned up promptly.