Euclid preparation XLI. Galaxy power spectrum modelling in real space