after the scandal / incident, people left him like the low tide ocean disappearing from the shore.
No one wanted a bar of him after they found out the scandal / incident
英語ではこのような形容はあまり使われないのでこのように言うと伝わらないかもしれませんが
質問を訳すのであれば
He was surrounded by girls and put up on a pedestal until then. But after the incident people left him like the low tide of the ocean disappears from the shore