What becomes of a written warning for speeding?

It depends on the locality. In some places they go on file with the department, in some places (usually small cities) the officer keeps them and probably eventually throws them away.