A man has been shot dead by police after a horrific stabbing in Caboolture, north of Brisbane on Tuesday morning.