Hallo Karrie -
It's a good idea to discard Cameron's over-simplification of 6 pulled from the water / only one boat returning, as that doesn't cover the complexities or controversies surrounding this issue.
Exactly how many people were pulled from the water, and by which boat, is still a matter of discussion and debate. Matters are complicated by the fact that many male survivors, probably fearful of the stigma attached to having survived, claimed to have been pulled from the water when they really left the ship in a lifeboat.
The boat depicted in Cameron's movie as having been the only one to pull people from the water is Boat 14 under the command of Harold Lowe. This did indeed take place, not unlike the scenes depicted in the movie, although how many people the crew of 14 pulled from the water is not known with certainty. Accounts range from three (with one perishing) upwards. The most commonly cited figure I've found in evidence suggests that four were pulled from the water, with one perishing. Most of those who survived seem to have been able to have supported themselves at least partially out of the water on wreckage.
Not shown in the movie were the efforts of Boat 4's crew and passengers to pull individuals from the water, both before the
Titanic sank and immediately afterwards.
Collapsible D also pulled one man from the water as the ship entered its final death throws - he was able to enter the water after putting his wife in D, and was brought aboard.
Others also survived by making it aboard the the overturned
Collapsible B, and Harold Lowe and the crew of 14 also rescued survivors who had made it aboard the swamped
Collapsible A. All these people had been in the water as well.
There is an article on the ET site that addresses the claims of various individuals to have been among those saved from the water:
https://www.encyclopedia-titanica.org/item/1499/