A proposal for a pop-up hospitality hub using shipping containers at a waterfront park in Southampton has been rejected.