If the user only published their notes to their own relay, then yes the notes would disappear while the RPI was offline. However, I think the most general use case for a self-hosted relay on a RPI is personal archival of your notes. Users would still post to multiple relays. Clients can also choose to cache notes for as long as they want.