re: Water heater exhaust to the roof is leaking

Think you're going to want to fix it from the outside and replace the boot, or at least add a repair boot like this:
LINK

Shouldn't see light coming through like your pic shows.