The sculpture runs nightly from dusk to 2am, visible from the Embarcadero, Rincon Park, and the bridge itself. It's free to watch from any of those vantage points. Rincon Park (at the foot of Beale Street) is the closest dedicated viewing spot on the SF side — the grassy area gives you a clean sightline without traffic in the frame. BART to Embarcadero, then walk south about 10 minutes. No parking situation worth fighting for.
What makes the clip interesting isn't the light show itself — most people have seen it — but the rigging process: workers on the cables in the dark, running wire across a working bridge. The scale of the physical installation is genuinely hard to appreciate from the shore.
If you've got two hours on a clear night, walk the Embarcadero from the Ferry Building south to Rincon, grab something from the Ferry Building beforehand, and watch the lights from the park around 8pm when it's fully dark but not late.