Are locked notes in the Notes.app are encrypted on the local host?
All user data on iOS devices is automatically encrypted. This includes any data stored in the Notes app.

Data on Mac computers is not encrypted by default, unless the individual app encrypts its data storage. It appears that data is stored in an unencrypted SQLite database, based on the fact there's a third-party export tool available.