Lille are a club with no future, even their manager walked away after last season. It was as good as it was going to get there last season, now they're back to being mid table in a poor league.
But at least they are still in a top tier division. Theres a significant chance of Newcastle being relegated ( I actually think they will ) , now in theory they should bounce straight back up but what if they dont, then Botman has swapped top league football for 2nd tier football for x years. Perhaps thats fine for him but if it was me, I'd rather be at a mid table team in the top national division than a team in the 2nd tier national division unless he see's the move as just a stepping stone to get him noticed in the Premier League with a view to then moving on to a bigger Premier League side