Greetings
Yes, it is expected that you need to reconfigure alerts on a restored Azure SQL database. When you restore a database, the alert configurations do not automatically carry over. Alerts are considered individual components and are not included in the database backup. Therefore, after restoring your database, you will need to manually set up your alerts again to ensure they function as intended.
Please find the links below for more information
Please do not forget "up-vote" wherever the information provided helps you, as this can be beneficial to other community members.
Regards
Geetha