So, I can just .....glue.... another connector on there? Is there no physical
connection? How does the signal get transferred from the connector into
the tuner?

In the interest of safety and knowing how to complete the repair safely
and properly, it is highly recommended that you have someone who is
experienced with fixing electronics do the repair.