Is magnificent an adjective

It is always an adjective. It can appear to be an appositive noun (e.g. Carnac the Magnificent) but this is part of a title using the adjective (e.g. The Magnificent Ambersons).