Having ridden in the front row with the headlights on, I've found that the headlights are really just there for show, nothing more. The ride feels exactly the same with the lights on and off. The only difference is that you can see a bit of track in front of you.
It would be cool to see the headlights diving toward the water though.