Hello 😊
In “What day is it today?” “today” is acting as an adverb. The answer is usually a day of the week not the date.
In “What day is today?” “today” is acting as a predicate nominative that completes a linking verb.
The answer is usually “Today is…” our anniversary, Independence Day, Friday.