The voltage gain in CB amplifiers relies on the impedance ratio of Collector to Emitter just like a negative feedback Op-Amp as the common base provides the bias current.
This means the emitter is like a virtual null. As the input signal modulates the emitter current thru to the collector, the voltage gain becomes a complex ratio of all the impedances for Zc/Ze.
The biggest problem in your layout is the unknown interwinding capacitance and resonant frequency. This breadboard may not be suitable, but essentially you can make it a series resonant to emitter with a parallel resonant collector to get a double-tuned high gain. Right now your gain is far off-peak to near unity.
Tuning the helical coil demands a precise shape close to the desired LC resonance to be effective. It would not be possible to have the wide tuning range for air coils as I have simulated.
When reducing Emitter resistance, the low impedance drops more and attenuates the input signal so when tuning Ce on emitter and Cc on collector, watch the Vpp output digital output.
Common Base Amplifier Confusion
Trying to plot input and output resistance for a single BJT in LTspice
The antenna impedance can also be tuned by choosing 20% longer than 1/2 wave to lower the impedance.
With significant effort in tuning the coils and all other parameters, you can achieve gains of > 1k (but not worth the sensitivity errors) Go for 30 dB gain.
Also, be aware tuning the coils together will increase C and you can also add discrete pF caps in close proximity it will be extremely sensitive to hand waving over the coils due to this layout.