TV on Kodi

Terrestrial (via aerial)? What country?

this one could work but havent tested myself,

Hauppauge DE | PCTV tripleStick 292e

PCTV Systems tripleStick T2 (292e) - LinuxTVWiki

still using eyetv netstream over ethernet, works well (recording over mac, livetv possible on linux with vlc or kodi with m3u channel playlist)

Hauppauge has reasonable kernel support (not the latest Nova 2) but Kodi doesn't support USB PVR tuners you also need a backend. LE has services for TVHeadend, NextPVR and VDR backends. You wrote antenna not aerial so maybe you are in US and Canada that would be ATSC.

There are also DVB-T and ATSC network tuners from Silicondust that will work without a backend.

Martin