Going by the Cambridge definition you linked above[1], indeed yes. I checked other reputable dictionaries and they are mostly similar.

But by these definitions a middle would also be a first name, which is confusing.

[1] the name that was given to you when you were born and that comes before your family name