I think the title was a play on words like . SUB(standard)MARINES .The mission was to retreive satelite from russua sea and I remeber laughing my but off like watching the spoof airplane .The ending was dodgeing russian subs on the radar screen but mocking a Football video game on the radar screen and screaming touchdown . I think 1995 saw it on cable
Possibly DOWN PERISCOPE (96)? http://www.imdb.com/title/tt0116130/?ref_=nv_sr_1 (http://www.imdb.com/title/tt0116130/?ref_=nv_sr_1)
But more likely GOING UNDER (1990) with the U.S.S. Sub-standard. http://www.imdb.com/title/tt0099675/?ref_=fn_al_tt_2 (http://www.imdb.com/title/tt0099675/?ref_=fn_al_tt_2)
Or maybe McHale's Navy (1997).
Solved . GOING UNDER 1990