Did Lord Frey Truly Aspire to Fight for Ned Stark?

Did Lord Frey Truly Aspire to Fight for Ned Stark? Lord Hoster Tully of House Tu