Why do pinhole cameras need long exposure times?

Because the aperture is tiny, so as to take advantage of the depth of field a small aperture will give. This lets pinhole cameras make sharp pictures without needing any way to focus them.