This isn't very rigorous, but here's one way to sort of get an intuitive grasp on this. You have an uncountably infinite set of sinusoid waves, one for every possible wavelength. That means that no matter what wavelength you pick, no matter how big or small it is, there's a sine wave in the set somewhere that has that wavelength.
Now say that you align the phases of every single one of these infinitely many sine waves such that they have a peak at the origin. So now, regardless of the exact details of how you do the integral, the resulting waveform is clearly going to have a peak at the origin. It has to--all of the waves are positive, and none are negative, so when the add up they're going to form a positive peak.
Now, as you move further away from the origin, the phases start to get out of alignment, and the total sum decreases in some way, meaning the peak falls off. This is the normal behavior for a wavepacket, regardless of whether it's made up of a finite or infinite set of sinusoids.
Now here comes the trick. You're worried that all of these infinite sinusoids are going to sync back up again at some other point and form another peak some distance away from the origin, let's call it X. But this is impossible, because our set of waves contains waves with every wavelength. So no matter what X is, there's a wave in the set with a wavelength of X/2, meaning it's at a trough at that point. In fact, any wave with a wavelength that divides that distance will have a trough at that point, so there are a whole bunch of waves in the set interfering destructively at point X.
So whatever else is happening at point X, we know that it isn't getting 100% constructive interference the way the origin is. So the total sum of the waves must be at least a little bit smaller at point X than it is at the origin. Since X was arbitrary, we've just shown that there's no other point anywhere along the real line that is getting as big a peak as the origin is. In other words, the origin is special--it's the only point where every single wave has a peak simultaneously. Therefore, the waveform can't be periodic.
The reason we were able to show this is that we knew that the set contained a wave with every conceivable wavelength, which can only happen if there's an uncountably infinite number of them. If it were finite, or countably infinite, then there would be some wavelengths that we wouldn't have. This means that there would be some values of X for which we couldn't guarantee that there is a destructively interfering wave, and the proof falls apart.