Yes, absolutely. You only need a television with an AV (composite) input—most modern TVs have at least one. Cable service is irrelevant.
The PS2 uses a composite cable with three RCA plugs:
If your TV lacks AV ports: Use an AV-to-HDMI converter (inexpensive, widely available).
After connecting: Select the correct AV input on the TV (often labeled "AV," "Video," "Composite," or "Input 1/2/3") to see the PS2 screen.
No cable box, no subscription, no internet required—just the console, cable, and a display.