Remove "allow failure" from Azure CI jobs

We had to allow the azure CI jobs to fail as they are doing so frequently and blocking/delaying releases. This issue is to track the revert of this change once the tests setup is fixed/stable.