Dual antagonistic role of motor proteins in fluidizing active networks