Oh, so sorry to see that!
But, like you said, you are relatively unscathed. I am sure once the Honda drivers insurance pays for your car and pain and suffering, you should be able to get a fancier New Beetle.
Anyway, Welcome to the Org (?)
and Good luck with your search a replacement.