Why was Brian overjoyed to see the tail of the plane sticking out of the water after the tornado?

Because that meant the plane was there, and him knowing the plane was there meant that he could scavenge the plane for whatever supplies he needed.