Is the referendum literally just to ask whether the constitution should recognise the First Peoples of Australia? Is there a good reason why the tally so far shows every state is voting no?

Yeh. Most of Australian do not want to enshrine racism in constitution.