This would mean 5000 rpm is much higher rpm than 10000 rpm.
Or your measurement is bogus.
How many cylinders? If each one makes a detonation noise, you have to multiply the RPM times that number. The one pulse per revolution per cylinder only holds true if there’s no muffler. The muffler’s job is to even out the individual exhaust pulses. You know how someone with a bad (or no) muffler goes down the street you can clearly hear each bang of each cylinder but it’s much harder with a proper system.
Does the engine have tuned exhaust? Those are designed to reduce detonation noise to near zero at certain speeds. If you measure one of those, you’re just going to get everything but the RPM, and the effect will come and go with speed.
And all that is assuming you didn’t overload the microphone or measurement system. This might be a good place for a dynamic (moving coil) microphone rather than one of the other types. They have an almost unlimited loudness range. If you don’t overload the preamp, you should be good to go. Dynamic microphones do have a loudness range, but it tends to self-limit rather than shorting out, exploding, or destroying themselves. That’s the business of never blowing into a microphone. It might be the last thing that microphone ever does.
Rock band microphones are almost all dynamic/moving coil types. They’re not indestructible, but they’re close enough. I had one Shure SM58 come back from a gig in two parts. It was still working.
Change Pitch and Change Tempo are the two effects most likely to damage the sound. Change Speed has much less distortion. It changes everything at once and doesn’t try to rip the sound apart and put it back together.
Interiors are designed to isolate you from the engine. Some of them are so well designed you can park a vehicle in a quiet lot and use it for a vocal recording studio.
You might be far better by taking careful measurements and use Analyze > Contrast to get the RMS or overall loudness measurement rather than trying to over-analyze it down to cylinder pulses. And even then, there are meters who do that for a living rather than forcing your computer to do it.
Some phones have an app that can do it, too.
One caution, there are two common measurements, A and C. C is relatively flat measuring all common sounds, A is the one that hears like your ear does, ignoring very high and very low pitch. Most hazardous sound laws are written in A.
Like all real world sounds, the exhaust sound is not a single-frequency and as Koz suggested the muffler & exhaust system act as a filter (or maybe like a tuned organ pipe*). And, the perception of pitch is complex. Musical instruments (and the human voice) create harmonics that make the note/pitch more defined than “random sounds”.
… It’s probably easier for a human to learn the correlation between the sound and RPM (for a particular engine) than for a computer to analyze it.
If there were one “pulse” per ignition, you’d have 8 pulses per revolution (a 4-cycle, 16 cylinders) and you divide by 60 to get Hz (cycles per second). At 5000 RPM that’s 667 Hz. But, the original “explosion” inside the cylinder most-likely contains all frequencies and is non-pitched.
The note from a pipe organ depends on the length of the pipe. But a pipe organ isn’t “activated” by an explosion or other “artificial” sounds so it puts-out a more-pure resonant tone.
I would globalize the sound of an entire revolution in one, since part of the sound may be affected by the structural behavior of the engine.
Take in account that engines with more cylinders produce a higher tone because they rev up higher, but at same RPM the sound is not necessarily in higher tone, since it is not proportional to engine’s cylinders quantity.
A V8 has a deeper-lower pitch than a 4 cylinder even thought the V8 is firing at twice the frequency (at the same RPM). A Ferrari V12 “sings” at a higher pitch than a V8 (maybe because the v12 revs higher). And, I’m pretty sure there is some relationship to cylinder diameter.
In the video, I DO hear the pitch increase with the revs but it’s not that pronounced until the engine really winds-up and it doesn’t “feel” proportional to the RPM. There SEEMS to be a LOT of “noise” that’s not related to RPM.
And, I didn’t see a tachometer in the video. (I didn’t watch the whole thing.)
That reminds me that there is a game, called “BMW M3 Challenge” where engine sound is not made from just one sample at constant revs, but they split the revs range into three or four ranges, each with its own pitch.