Ch9 Syd, reported the plane took off, turned and "dipped" with pax on the inboard side only able to see water, whilst pax on other side saw QF plane coming at them. All pax terrified and everyone pooed their pants. The non-normal checklist poo on seats was carried out and a/c landed safely.