So its the most famous street in London where normal traffic isnt
allowed but it doesnt seem to be enforced at all leading to quite a
lot of supposedly banned traffic using it.

Or does it mean that traffic is banned except for unloading, local
access, disabled traffic, minicabs etc. so infact its much like a
normal road?

Just a niggling thought