Plans to flatten an abandoned Aldi and replace it with retirement homes are set to be appealed after a council rejected the proposals.