Yes, of course your son and your great niece are related. They are first cousins, once removed, to each other. (Your great niece's parent, your niece or nephew, and your son are first cousins to each...
Your great grandfather's great niece is the grandchild of his brother or sister. That makes her the second cousin of your mother or your father, and therefore your second cousin, once removed.