Essentially Tight Kernels For (Weakly) Closed Graphs