A “hookup” is a connection point, generally.
Most of the time, people say “hook up” to mean a romantic connection. Usually just fucking. Or if you are super young, “hook up” might mean kissing, but once you are a later teen or older, hook up means sex.