And without a burrow speed, and without a ranged attack, and without an ability that lets it ground all flying enemies.
Giving the Tarrasque a burrow speed goes a long way towards improving it, I agree. The hurl boulder ability of giants wouldn't hurt either, although there's really nothing stopping a Tarrasque from hurling rocks with a standard BAB.
I wouldn't mind giving the Tarrasque a breath weapon, either. It works for Godzilla.
But these are incidental improvements. Just ambushing players in a cave will go a long way towards negating it's deficiencies, even at high levels.
you can deal limitless damage just by dropping sufficiently many 100 pound boulders
Catapults are popular for a reason. But there's still some issue of ammo and opportunity. You're really banking on your target just hanging out at the optimal firing range.