You're correct: methane would not work well as a replacement for conventional aviation fuel both for the reason you mention (weight of storage system) as well as the lower energy density per unit volume: 35 MJ/L for jet fuel vs. 9 MJ/L for compressed natural gas at 3600 PSI. (https://en.wikipedia.org/wiki/Energy_density)