Is mRNA (messenger RNA) the only type of RNA that is translated into proteins?

Yes, that is correct. No other cles of RNA are translated by ribosomes into proteins except for mRNA.