If the site uses Flash based videos then it won't play natively on the iPad. Mobile safari doesn't support flash. You'd need to use a flash based browser, I see Puffin, Skyfire and iSwiffer recommended. But none of them seem to be perfect, so you may want to experiment before you plunk down any money.
You might also want to see if the site you're trying to access has an app.