Celebrity memoirs, breathless lives of 18th-century socialites and countless royal mistresses - whatever happened to the golden age of biography? And what is the future for a genre in which the best subjects have already been written about, time and again, asks Kathryn Hughes.