TV/movie where a routine battle response drill on a spaceship turns into an actual battle

Star Trek Voyager - Favorite Son.

When Voyager encounters an alien ship they have never seen before (the Nasari ship Nerada), Kim instinctively transfers tactical control to his station. Though the Nasari show no apparent hostile intent, Kim raises Voyager's shields and fires phasers without orders, claiming that the alien vessel is charging weapons.

Voyager takes heavy damage in defending itself from the Nasari vessel, forcing them to withdraw. Janeway demands Kim explain his actions, and Harry tells her that he just knew the Nasari were going to attack. Tuvok says he detected nothing but a tetryon surge coming from their ship, and points out that there could be any number of explanations for that. Kim is suspended from duty, and shadowed by a security guard, pending investigation of his overly-hostile actions.

Kim reports to the captain's ready room and admits fault about starting the last engagement. Janeway reveals that he was right about the Nasari ship charging weapons, and they would have caught Voyager with her shields down had he not acted. The question now is how did Harry know they were going to attack. Kim can only say this part of space has become increasingly familiar.

It sounds like the 2009 version of Star Trek. The crew learns of the danger of an ambush from Chris Pine(eventually Captain Kirk) who stowed away to warn the captain of a possible ambush due to the language being used over the comms(I think romulan). The captain(Pike), knew Kirk was someone he should listen to, and orders the red alert/battle stations/head between legs to kiss ass goodbye. Turns out-the warning was right and the crew manages to escape a situation that wiped everyone else out. They come out of hyperspace right on top of the end of the battle-with ship debris everywhere and a giant enemy ship.