One of Ireland’s biggest and best-known lagoons has become so polluted it would take “millions of euro” to reverse it, the authors of a scientific study have said.