An attempt to topple the Lancashire County Council cabinet member responsible for special needs services for children has failed.