A search for one of Australia's most-wanted fugitives, Dezi Freeman, has ended with him being shot dead by heavily armed police.