[test] convert export test to handle exception rather than early return

[test] convert export test to handle exception rather than early return

This is part of switching to testing the eventual output rather than the temp table created. In most cases the temp
table is not truly needed so testing the real output makes more sense