No, you cannot play a standard CSI DVD movie or "DVD game" on a PlayStation 2. The PS2 reads game discs formatted specifically for its architecture, while video DVDs use a different file structure and encoding.
If you want to play CSI on a PS2, look for these native titles:
These are available on second-hand markets (eBay, local game stores) and will run natively on any PS2.