Southampton students union president resigns after vowing to paint over First World War mural