The former deputy Labour leader said Sir Keir Starmer must "meet the moment" following disastrous local election results