Then that is about right...to get 400GB on a 200GB tape in 2:1 compression is pretty much best-case scenario. I haven't seen it before, although it is possible.
Your only way to sort this out would be...
1. Continue spanning over 2 tapes.
2. Buy a larger tape drive (be it stand-alone, autoloader, library) and the associated tapes.
3. Clean up some files and folders and therefore make the backups smaller. Look at excluding files like *.mp3, *.wav etc.
Some files are compressed already, meaning Backup Exec won't compress them further. I think that what you're getting is the best you will get on those tapes in your current setup.
Laters!