Are you sure the net happiness from football was really raised by Messi or did he simply shift it to his county and teams he plays for?

Yes

If you take away his great play doesn't it just make other players stick out more, and fans would derive happiness from other players?

No

Greatness isn't ONLY about being greater than others.