This term is used to describe something that is big, has little use, and expensive to maintain. These things often seem great at first, but after a while they become annoying because they are too costly and of little use.
Example: “Many people are worried that the new stadium being built for the Olympics will become a white elephant after the games are finished.”