Loathed 13ft statue of ‘Prince Philip’ disowned by its artist and branded ‘poorest quality work’ must be pulled down