Oh, I do think it is automated or at least powered already - although it may have been dormant/software disabled on the mules until now in public to keep it secret? We have seen it wrapped shut on some of the mule(s) or missing entirely its cover-piece.
Whilst I too would have expected the first sighting of the adaptive spoiler on a freeway, given that is how the German examples use it, those same German cars usually have a button to activate the spoiler at any speed - Model X could too. Although I would expect the button to be a touchscreen one. Maybe the user can change the spoiler behavior.
Then again, Tesla might be just testing something here, the speed of the car might be higher than we can construe, and/or Tesla has a wholly different algorithm as to when to open the spoiler.
I guess the best theory currently is, Tesla is using the spoiler for range improvements rather than downforce improvements, but who knows - maybe it is for both reasons.
Photo is on a city street, traffic is in front of the Tesla with brake lights on, Tesla's brake lights are on, and there is probably a traffic light in front of it. If the spoiler is supposed to be improving aerodynamic drag, it would make absolutely no difference at those speeds.