Mirroring for Azure SQL database in Fabric is currently in GA and you should be able to use it in production
https://techcommunity.microsoft.com/blog/azuresqlblog/announcing-the-general-availability-ga-of-mirroring-for-azure-sql-database-in-mi/4303936