Nah, not if you're bottom watering using terracotta. The water wicks through the terracotta into the soil.
If you're top watering (pouring water into the top of the soil) then yeah drainage holes would be needed. But most plants are much happier with bottom watering and it encourages a better root system.