There are more forest cards than any other terrain, so: Yes, forest give the most points.

But! You get exactly 26 (pair of) cards, so it is about using them as best as possible.

You have 11 Forests for 27 points, that is approximately 2½ point pr. forest.

You have 2 Mountains for 12 points, that is 6 points pr. mountain.

You have 1 Church for 10 points!

In reality it is about combining the terrain types so they give points, and here forest are slightly better due to there are more of them, and thus they are more chances to place forests so they generate points.