I can't see how it can make money. People don't visit Dubai to stay in what is otherwise a tarted up Western museum piece of a hotel but with premium prices, despite her "fame". The latter will of course gradually dissipate as the years go on as the memory of her in service fades.
She's still going to end up going up a beach somewhere, the only question is when.
The QE2 is berthed at the former Dubai cruise terminal which now houses an exhibition before boarding the ship, the whole area is being developed with apartments, restaurants, shops with the QE2 Hotel being centre stage.