This is because the sine wave is of finite duration. Consider the linear autocorrelation of a rectangular pulse - the result is a triangle given the autocorrelation is a sample by sample product (complex conjugate product for complex waveforms) and sum for each an every offset between the two in time. The OP's case is that for a sine wave multiplied by a rectangular pulse, so we get the same envelope as a triangular function combined with the expected periodicity due to the sinusoid.
This is demonstrated as an animation below where the top part of the figure shows two rectangular windowed sinusoids as the offset between the two is changed. The middle part of the figure shows the sample by sample product. For any given offset, the array of all products is summed (the entire middle graphic) to create the one sample indicated by the moving circle in the lower graphic. From this we also see intuitively why the magnitude will increase linearly and then decrease as more or less of the two waveform overlap, resulting in more non-zero samples in the sum for the total correlation result at any given time offset.

The resulting autocorrelation for this example is given in the figure below:

If you instead do a circular correlation function, then you will see the correlation result constant for all offsets (or in the case of your sinusoid, a constant envelope), which would be equivalent to a linear autocorrelation with the sinusoid extending to $\pm \infty$. This can be implemented using the fft as follows:
$$\text{CIRCORR} = \text{IFFT}\bigg\{\text{FFT}\{x[n]\}\text{FFT}\{y[n]\}^* \bigg\}$$
Where the $(^*)$ represents a complex conjugate. The above shows the more generalized cross-correlation function for $x[n]$ and $y[n]$. Replace $y[n]$ with $x[n]$ to get the autocorrelation function.
To demonstrate this, below is the magnitude plots for linear autocorrelation and cross-correlation for the pseudo-random noise sequences (C/A Code) in GPS signals from SV24 (SV = Space Vehicle) and SV7. Below that I show the same result using the circular autocorrelation and cross-correlation approach introduced above with FFTs:
LINEAR XCORR:

CIRCULAR XCORR:
