Actually, on a serious note, the fate of the Enterprise B is something that should be addressed. It couldn't have been decommissioned, Excelsior class ships continue on into the late 24th century. We even see one Excelsior class variant with the same modifications as the Enterprise B, the USS Lakota.
That would leave only destruction. But if it were destroyed, that would mean out of the seven Enterprises (NX-01, NCC-1701, A, B, C, D, E) four were destroyed, two decomissioned, and one still in service. Honestly, with those statistics, the name Enterprise seems like a curse and that the ship is likely to be destroyed.
Of course, we could always be smartass and assume for some reason the Enterprise was renamed Lakota...
there's an article at ex astris scientia where some one made that very claim.
I believe the NX-01 is in a musuem, didnt troi visit it as a girl?
correct.