Wakefield Council plans to replace its "ageing" bin lorries with a fleet of diesel vehicles after attempts to go electric were unsuccessful.