The Farrer by-election delivered a historic result that could represent an "existential situation" for the Coalition.