Yes, you use the PS2 Light Gun to play that game (Time Crisis 3, by Namco).
Hmm, actually, there is a Resident Evil game called Death Aim on PS2 which is fully compatible with the Light Gun as well.
I have a Vampire Night for PS2. It came with a light gun. It's pretty fun but not anywhere near the fun I had with Duck Hunt or Hoggans Alley.