Atmospheric density decreases exponentially with height.
Total impulse required to blow through drag forces is a nasty nasty power law.
It wouldn't be that difficult to make a linear rail launcher in a vacuum, or on the moon. Air resistance really is the whole problem.
If you can put the launcher above the atmosphere, it's 100% worth the effort.