Yes let's focus on that one because it was your last chance. You were at home in your final home game of the season, your manager wanted an electric atmosphere and said himself he was shocked at what he found. Maybe you'd still lose the game if the fans had been more on your side, but it can't have hurt though. If you'd beaten City, Villa's fixture was a pretty horrible one away from home and you had the easiest final fixture imaginable. It really was there for you.
Also, that's always such a weird thing to say about the CL too, even when United fans say something similar like ' there's no point in being in the champions league, because we'd never win it anyway'. The point is you get better opportunities to strengthen the squad, more money for better players, and an excitement around the club.
Anyway, it doesn't really matter what I think, your manager made the point perfectly. Personally, as a United fan I'd much rather see Spurs do well than City, Arsenal, Liverpool, Chelsea etc but your club doesn't make it easy.