IMO, most songs should have 3,4 or 5 verses.

Two verses is nearly always too short, and one or more has to be repeated.

More than 5 is too long, your audience will start to get bored.

Of course there are exceptions! There are some short songs that are very pretty and complete in themselves. And there are story songs that need more than 5 verses to get the full story across (although some still take too many verses to get there!)

But as a general rule, when writing or performing a song, I'd say 3-5 verses is the optimum length.