U.S. Navy ship targeted in failed missile attack from Yemen