What to do?

I got an email from my friend Todd a few days ago telling me he will not be able to do the Ocean City Tri with me. Now Im stumped...my chiropractor told me he would not recommend me doing any more events this season, and I was going to go against his advice and just do this last one...even if I only do it as a Aquathon (swim and bike), which I could do without issue, I believe. But my motivating factor (outside of the money I spent to do the event) was that I would be letting Todd down if I didnt do it, especially as I talked him into it, and its his first event. Not only that, but there are about 20 cool things happening in my neighborhood that weekend that I would love to be a part of (the arts fest, the univest bike race, etc, etc)...and now i have nowhere to stay down near the event unless I shell out for a hotel room by myself...and down the shore those can be pretty pricey. I dont know anyone else doing the event, or anyone else that will be in Ocean City that weekend, so for now, the cons are definitely outweighing the pros.

I could always get up super early the morning of the 13th (ie 3am), drive to OC, do the event, drive back and get home by 1pm, and then crash...but that sounds like a pain in the ass.

What would you do? So much for my certainty and visualization, huh?