I think Tampa is done. I actually concluded that before Game 6. I was actually surprised that they were fortunate enough to win Game 3, while unlucky in Game 4; losing Game 5 was very painful since the line up & starters were ones in which the Rays probably wouldn't be able to score while starting pitching was unable to last long. Houston's bullpen is not bad, but I cannot say the same for Tampa.
In my opinion, this pales in comparison to the 2004 Yankees. Unlike New York, the Rays are a small market team where a postseason run is a nice bonus. Furthermore, they're playing 7 games in 7 days. That being said, there's no excuse to blow a series lead. The Astros are playing 7 games in 7 days as well. The 2004 collapse was a lot more painful based on the participants; at the same time it might have been a nice treat for the other half!