Mixing is at its simplest just multiplication.
There's plenty of scholarly treatments out there, my first two hits were
ftp://ftp.analog.com/pub/cftl/ADI%20Classics/Basic%20Linear%20Design%20(Linear%20Circuit%20Design%20Handbook),%202007/Chapter_4_RF_IF_Circuits.pdf
https://www.digikey.com/en/articles/techzone/2011/oct/the-basics-of-mixers
but your mixer is simpler than those high performance IC's.
Thought experiment
What if i could modulate a resistor's value at one frequency , f1
and force current of another frequency f2 through it ?
By ohm's law the voltage across the resistor would be their product f1f2, wouldn't it ?
end thought experiment...
" Transistor " is a compound word , a combination of 'transfer' and 'resistor'.
I think of the transistor as a resistor (collector to emitter) whose value is modulated by base current.
So does this Berkeley professor , (properly giving credit, it's at)
http://rfic.eecs.berkeley.edu/~niknejad/ee242/pdf/ee242_mixer_fund.pdf
View attachment 233015
and that's what your single 2N3904 mixer is doing
(though emitter and collector are swapped from that professor's explanation)
Oversimplifying a little just to get started:::
2N3904's collector current is local oscillator frequency
and RF comes in on the emitter
base is effectively 'grounded' for signal by C14
so emitter-base current is RF input
and collector current gets multiplied by collector resistance which varies with base current at RF input frequency
and collector voltage is the product of the two frequencies
C17B sets Local Oscillator frequency
D3 trims local oscillator frequency to keep it centered on the station being received.
It really does work. Designers in early 20th century did it with four prong vacuum tubes.
https://www.radiomuseum.org/tubes/tube_30.html
View attachment 233018
it really is that simple, in concept.
You should go through the trigonometry of multiplying cosines having different frequencies , if only to appreciate the genius of our predecessors.
Then it's time to refine the description to include C3 and C23...