Plans for a major housing development in Blackpool have been thrown out by councillors who heard residents already live in fear of flooding.