The former Manchester United striker left Derby County in 2022 after failing to save them from relegation to League One