Pros outweigh cons here, people:
Improved infrastructure.
Team automatically qualifies for World Cup especially if you are Canada, USA or Mexico
Getting revenues in form of tickets sold, merchandise, selling TV rights, etc.
Give other countries' national teams a chance to shine on the world...