Does Loose Cannon check my hand size when it triggers or when it resolves?

That condition is part of the effect because of where it appears in the text. The ability can trigger at the start of your Beginning Phase, then checks the hand-size condition as it resolves.