Channing Tatum and Amanda Seyfried's Dear John has taken the top spot at the box office this week, knocking off Avatar from its seven-week perch on top of the table