Why is there a limit to zooming in on a picture?

Basically the title.

Do pictures really need a limit to how far you can zoom?

It annoys me to no end when there's a larger image that I'd really like to zoom in to view a detail and I run into an arbitrary wall just too far away.