> does Google still have another messaging service attached to their SMS app

Google Messages (the default SMS app on newer phones) uses RCS if available and overlays E2E encryption on top using the Signal protocol.