Basically every dedicated RF generator will be a sinewave output with no modulation, as this is a CW tone and as harmonics can be extremely problematic in RF applications. That said, generating a clean tone can be very difficult when you're also optimizing your generator to have a wide frequency range and a quick settling time so you can sweep quickly, so it never works out to be perfect. ESG specification of 30dBc means that there is 1/1000th of the power in the second harmonic and above than is in the primary tone - the irregularity is definitely measurable, but if you put the signal on a scope it would just look like a sine wave. Very good generators can manage 50dBc or better, but they become reliant on external filtering much beyond that.
As a comparison, AD specifies the second and third harmonic content in the ADF4351 datasheet (and these will be most of the power in the harmonics), and they're about 10dBc worse (10x worse) or more than the ESG's specification. it will still look like a sinewave, but it's a much less sinusoidal signal than the ESG or another full generator will produce.
Harmonic distortion at these kind of frequencies can come down to tiny imperfections in cable and connector geometry, so it's not realistic to expect performance as you'd see in the audio band (for example) without heavy filtering.