If by air attack you include missiles, then absolutely. HMS Sheffield, Coventry, Ardent, Antelope, Atlantic Conveyor, USS Stark. various Argentine gun boats, the entire Iraqi navy (well done Sea Squa team). The only submarine action was Conqueror. So yes, I would say that is a fair comment.
When ships fight aircraft the result is usually the same.