Are cavities just small holes in the teeth?

Could be .. They can be small or large and are caused by bacteria - untreated they will most likely get bigger, although early ones can be reversed.
Y but not always sm. Cavities may start small but once they get through the outer enamel layer of the tooth they can become large rather quickly. Proper brushing, flossing and diet are the best ways to prevent cavities.