Hi fella,
there should be a seal around the opening.
A typical issue is water ingress through the rear lights. The seals on these often go and is a common problem.
Check for any rips or tears in the hood area around the tonneau cover side trims.
Often there is a split here on older hoods.
Also check the tailgate lock seal is not split or missing.
Hope that helps a bit.