I think the short answer is that if Naval Warfare is synonymous with 2 big ships pounding poo out of each other with big guns, it's dead. That's only because we have more efficient means of fighting in the Maritime Battlespace, though. So no, it's not dead. Land projected Air Ops have significant limitations and it's unfortunate that the fixation on Land Ops has been allowed to cloud the views of many people who should know better.
For as long as people and material move by sea (and over it if it's far enough from land) and Nations have coastlines, the need for Naval Warfare will remain very much alive.
Strictly speaking the organic Lynx is (excuse me, was) a Type 42's only surface to surface weapon and was given targeting info by the ship itself so semantics not withstanding, it could be referred to as a ship to ship engagement. Not much different to OTHT with harpoon except where the weapon is launched from and where the info originates. I guess it can be seen both ways though.
I also think South and North Korea have been trading fisticuffs at sea in the past few years. Sri Lanka also springs to mind, can't be arsed to google it though. Might be wrong, probably am.
I was embarked in GLOUCESTER at the time and her Lynx did much of the damage. Just like a carrier's FW aircraft, a DD/FF's helo is part of the ship's weapons system and is used for ASuW, ASW and even land attack.
The Battle of Bubiyan was a naval engagement of the Gulf War, that occurred in the waters between Bubiyan Island and the Shatt al-Arab marshlands, where the bulk of the Iraqi Navy, while attempting to flee to Iran, much like the Iraqi Air Force, was engaged and destroyed by Coalition warships and helicopters. The battle was completely one-sided.
The initial attack by three Lynx helicopters of the Royal Navy using Sea Skua missiles destroyed five TNC 45 fast attack craft, a landing craft and two Zhuk class patrol boats, before the US Navy aircraft arrived. The battle saw 21 separate engagements over a course of 13 hours. A total of 21 of the 22 ships that attempted to escape were destroyed...
North Korea denied torpedoing the SK frigate Cheonan a few years back, which would have convinced a little more if they hadn't promptly slapped up a propaganda poster celebrating it...
The Sri Lankans had some painfully lively encounters with the LTTE (Liberation Tigers of Tamil Eelam) at sea as well as on land in the early 2000s, as well.
Other naval excitement includes occasional incidents (up to exchanges of gunfire and occasional casualties) in the South China Sea around the Spratleys, at least one Georgian warship sunk by the Russians in the South Ossetian unpleasantness, an Israeli corvette clipped by a missile nobody knew Lebanese Hezbollah owned (and a merchant ship minding its own business, sunk by the same salvo) in 2006... plus the whole "Pirates of Somalia" saga, which has died down but not gone away completely.
While we're not expecting a Tom Clancy-themed bout of nautical ultraviolence with entire flotillas annihilating each other with sky-blackening salvoes of nostalgically-named fUSSR missiles, I would bet against a co-ordinated global outbreak of niceness, peace and brotherly love on all seven seas at once.