While Rory does read Avengers comics, I doubt he'd recognize Coulson from those, since even if he saw Coulson in the comics I doubt he'd draw the connection, but I checked and Avengers was released before the last episode of My Babysitter's a Vampire, so he might recognize him from that, though he might not notice right away since he's not expecting to run into Agent Coulson.