Rotterdam’s new €175m market hall comes complete with apartments looping over it – some peeping out of giant avocado stones. It’s proudly pop, but is it just the Comic Sans of architecture? Oliver Wainwright reports