It's ok, but the game core gameplay must be solid and not focused entirely on grinding. Also, the game must be good overall: good story, good characters, good cs and mechanics should be well structured and meaningful.
Example of a game where I think grinding is bearable is Persona 5.
XCX and XC2, however, are terrible in this respect.