A major search and rescue operation is under way for a 23-year-old man who slipped and fell into Brisbane River.