Without a doubt, a properly installed tile floor will last several lifetimes.

From the description given, your floor joists needed to be beefed up to reduce the deflection and prevent graced grout.

Unless the joist deflection is corrected, a vinyl floor is a good choice.

There are tile installations that have lasted 1000's of years.