I was not driving our truck when the flex plate failed so I can't speak to the noise you are hearing.
However if it does fail the truck is done moving at that point. So you'll have to have it towed, etc....
When ours failed it was 10 hours away from home so we had a local shop replace it instead of towing it back home and doing it here.
The advice I received on this forum is that you need to pull the transmission back so you can get at it and although not requiring any specialty tools you do need to be comfortable doing that type of work. More importantly I always find having a good place to do the work with the correct jacks, stands, etc... invaluable.
there is a way you can inspect it using a flexible inspection camera to see if it is developing a crack.
That info including representative sounds available here:
https://mike-thomson.com/blog/?p=1842
Hope this helps