The plan for the mission had been to send the ship on one near-complete revolution of the Earth, ending with a splashdown in the Pacific, a couple of hundred km north of Hawaii.
There was no expectation that the ship or Super Heavy would be recovered. However, long term, this is the plan. The idea is to land both halves, refuel them and launch again - over and over.